| 123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263 |
- <!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>
|
