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