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 @@
+<!doctype html>
+<html>
+  <head>
+    <title>CodeMirror 2: Oracle PL/SQL mode</title>
+    <link rel="stylesheet" href="../../lib/codemirror.css">
+    <script src="../../lib/codemirror.js"></script>
+    <script src="plsql.js"></script>
+    <link rel="stylesheet" href="../../theme/default.css">
+    <link rel="stylesheet" href="../../css/docs.css">
+    <style>.CodeMirror {border: 2px inset #dee;}</style>
+  </head>
+  <body>
+    <h1>CodeMirror 2: Oracle PL/SQL mode</h1>
+<form><textarea id="code" name="code">
+-- Oracle PL/SQL Code Demo
+/*
+   based on c-like mode, adapted to PL/SQL by Peter Raganitsch ( http://www.oracle-and-apex.com/ )
+   April 2011
+*/
+DECLARE
+    vIdx    NUMBER;
+    vString VARCHAR2(100);
+    cText   CONSTANT VARCHAR2(100) := 'That''s it! Have fun with CodeMirror 2';
+BEGIN
+    vIdx := 0;
+    --
+    FOR rDATA IN
+      ( SELECT *
+          FROM EMP
+         ORDER BY EMPNO
+      )
+    LOOP
+        vIdx    := vIdx + 1;
+        vString := rDATA.EMPNO || ' - ' || rDATA.ENAME;
+        --
+        UPDATE EMP
+           SET SAL   = SAL * 101/100
+         WHERE EMPNO = rDATA.EMPNO
+        ;
+    END LOOP;
+    --
+    SYS.DBMS_OUTPUT.Put_Line (cText);
+END;
+--
+</textarea></form>
+    <script>
+      var editor = CodeMirror.fromTextArea(document.getElementById("code"), {
+        lineNumbers: true,
+        matchBrackets: true,
+        indentUnit: 4,
+        mode: "text/x-plsql"
+      });
+    </script>
+    <p>
+        Simple mode that handles Oracle PL/SQL language (and Oracle SQL, of course).
+    </p>
+    <p><strong>MIME type defined:</strong> <code>text/x-plsql</code>
+    (PLSQL code)
+</html>

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	*/
	21	DECLARE
	22	vIdx NUMBER;
	23	vString VARCHAR2(100);
	24	cText CONSTANT VARCHAR2(100) := 'That''s it! Have fun with CodeMirror 2';
	25	BEGIN
	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);
	44	END;
	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>