# CodeMirror 2: Oracle PL/SQL mode

-- 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; --

Simple mode that handles Oracle PL/SQL language (and Oracle SQL, of course).

MIME type defined: `text/x-plsql` (PLSQL code)