upstream/ipython Files · IPython/frontend/html/notebook/static/codemirror/mode/plsql/index.html

Merge pull request from takluyver/catch-histdb-errors...

Merge pull request from takluyver/catch-histdb-errors Catch sqlite DatabaseErrors in more places when reading the history database It seems sqlite can encounter corruption and throw an error when reading the database, although it has connected successfully. This borrows the move-and-recreate machinery we already had on connecting to the database. If such an error occurs, the corrupted file is moved and the user get warned of the name of the corrupted file.

Matthias BUSSONNIER - - Load All Authors

File last commit:

r8053:58574fbf


                r8503:7904325b

Download file

             index.html
        
                    62 lines
            
             | 1.5 KiB
            
                | text/html
            
             |
                HtmlLexer
            
             / IPython / frontend / html / notebook / static / codemirror / mode / plsql / index.html
          
                    History
                
                 |
                  Annotation
                 | Raw
                 |Copy content
                 |Copy permalink

      <!doctype html>

      <html>

        <head>

          <title>CodeMirror: 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="../../doc/docs.css">

          <style>.CodeMirror {border: 2px inset #dee;}</style>

        </head>

        <body>

          <h1>CodeMirror: 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>

	Site-wide shortcuts
/	Use quick search box
g h	Goto home page
g g	Goto my private gists page
g G	Goto my public gists page
g 0-9	Goto bookmarked items from 0-9
n r	New repository page
n g	New gist page

	Repositories
g s	Goto summary page
g c	Goto changelog page
g f	Goto files page
g F	Goto files page with file search activated
g p	Goto pull requests page
g o	Goto repository settings
g O	Goto repository access permissions settings
t s	Toggle sidebar on some pages

				<!doctype html>
				<html>
				<head>
				<title>CodeMirror: 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="../../doc/docs.css">
				<style>.CodeMirror {border: 2px inset #dee;}</style>
				</head>
				<body>
				<h1>CodeMirror: 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>