diff options
Diffstat (limited to 'imports/codemirror/mode/plsql/index.html')
-rwxr-xr-x | imports/codemirror/mode/plsql/index.html | 62 |
1 files changed, 62 insertions, 0 deletions
diff --git a/imports/codemirror/mode/plsql/index.html b/imports/codemirror/mode/plsql/index.html new file mode 100755 index 00000000..be603d99 --- /dev/null +++ b/imports/codemirror/mode/plsql/index.html | |||
@@ -0,0 +1,62 @@ | |||
1 | <!doctype html> | ||
2 | <html> | ||
3 | <head> | ||
4 | <title>CodeMirror: Oracle PL/SQL mode</title> | ||
5 | <link rel="stylesheet" href="../../lib/codemirror.css"> | ||
6 | <script src="../../lib/codemirror.js"></script> | ||
7 | <script src="plsql.js"></script> | ||
8 | <link rel="stylesheet" href="../../doc/docs.css"> | ||
9 | <style>.CodeMirror {border: 2px inset #dee;}</style> | ||
10 | </head> | ||
11 | <body> | ||
12 | <h1>CodeMirror: Oracle PL/SQL mode</h1> | ||
13 | |||
14 | <form><textarea id="code" name="code"> | ||
15 | -- Oracle PL/SQL Code Demo | ||
16 | /* | ||
17 | based on c-like mode, adapted to PL/SQL by Peter Raganitsch ( http://www.oracle-and-apex.com/ ) | ||
18 | April 2011 | ||
19 | */ | ||
20 | DECLARE | ||
21 | vIdx NUMBER; | ||
22 | vString VARCHAR2(100); | ||
23 | cText CONSTANT VARCHAR2(100) := 'That''s it! Have fun with CodeMirror 2'; | ||
24 | BEGIN | ||
25 | vIdx := 0; | ||
26 | -- | ||
27 | FOR rDATA IN | ||
28 | ( SELECT * | ||
29 | FROM EMP | ||
30 | ORDER BY EMPNO | ||
31 | ) | ||
32 | LOOP | ||
33 | vIdx := vIdx + 1; | ||
34 | vString := rDATA.EMPNO || ' - ' || rDATA.ENAME; | ||
35 | -- | ||
36 | UPDATE EMP | ||
37 | SET SAL = SAL * 101/100 | ||
38 | WHERE EMPNO = rDATA.EMPNO | ||
39 | ; | ||
40 | END LOOP; | ||
41 | -- | ||
42 | SYS.DBMS_OUTPUT.Put_Line (cText); | ||
43 | END; | ||
44 | -- | ||
45 | </textarea></form> | ||
46 | |||
47 | <script> | ||
48 | var editor = CodeMirror.fromTextArea(document.getElementById("code"), { | ||
49 | lineNumbers: true, | ||
50 | matchBrackets: true, | ||
51 | indentUnit: 4, | ||
52 | mode: "text/x-plsql" | ||
53 | }); | ||
54 | </script> | ||
55 | |||
56 | <p> | ||
57 | Simple mode that handles Oracle PL/SQL language (and Oracle SQL, of course). | ||
58 | </p> | ||
59 | |||
60 | <p><strong>MIME type defined:</strong> <code>text/x-plsql</code> | ||
61 | (PLSQL code) | ||
62 | </html> | ||