Warning, file /frameworks/syntax-highlighting/autotests/html/test.sql_oracle.dark.html was not indexed or was modified since last indexation (in which case cross-reference links may be missing, inaccurate or erroneous).
0001 <!DOCTYPE html> 0002 <html><head> 0003 <meta http-equiv="Content-Type" content="text/html; charset=UTF-8"/> 0004 <title>test.sql_oracle</title> 0005 <meta name="generator" content="KF5::SyntaxHighlighting - Definition (SQL (Oracle)) - Theme (Breeze Dark)"/> 0006 </head><body style="background-color:#232629;color:#cfcfc2"><pre> 0007 <span style="color:#7a7c7d;">-- </span><span style="color:#3f8058;">kate:</span><span style="color:#7a7c7d;"> </span><span style="color:#7f8c8d;">hl</span><span style="color:#f44f4f;"> SQL (Oracle)</span> 0008 <span style="color:#7a7c7d;">-- test case shipped with highlighting in bugzilla, LGPL</span> 0009 0010 <span style="font-weight:bold;">declare</span> 0011 v_nchar <span style="color:#2980b9;">NCHAR</span>(<span style="color:#f67400;">12</span>); 0012 <span style="color:#fdbc4b;font-weight:bold;">begin</span> 0013 <span style="color:#3f8058;">q'{</span><span style="color:#f44f4f;">adfasdf'sadfasdf j</span><span style="color:#3f8058;">}'</span>{<span style="color:#f44f4f;">' hkjhkhkjhkjh khlkhklj'</span>fghdfghdfgh<span style="color:#f44f4f;">'hkjh'</span>jkhkh<span style="color:#f44f4f;">'a'</span> 0014 <span style="color:#3f8058;">nQ'(</span><span style="color:#f44f4f;">asldflahsl;'dkjfhklsdfh</span><span style="color:#3f8058;">)'</span> 0015 <span style="color:#3f8058;">Nq'[</span><span style="color:#f44f4f;">asdasd;'asdasd'a]sd'asd'asasd</span><span style="color:#3f8058;">]'</span>;<span style="color:#f67400;">11111111</span>[<span style="color:#f67400;">1</span><span style="color:#f44f4f;">']; asdasdasdasd'</span>errrrrrrrrrrrrrr<span style="color:#3f8058;">-</span>p 0016 0017 <span style="color:#3f8058;">nq'a</span><span style="color:#f44f4f;">gdfgsdfgfhfghjfgh'f'f'sdfg'sdfg'dfg#</span><span style="color:#3f8058;">a'</span> dafdfadasfasdf; 0018 v_nchar <span style="color:#3f8058;">:=</span> <span style="color:#3f8058;">n'</span><span style="color:#f44f4f;">NCHAR STRING'</span>; 0019 if_n <span style="color:#3f8058;">:=</span> <span style="color:#f67400;">0</span>; 0020 0021 <span style="color:#3f8058;">Q'#</span><span style="color:#f44f4f;">gdfgsdfgsdfgsdfgsdfg</span><span style="color:#3f8058;">#'</span> afgasasdfasdfasfasdfasdfasdfasdfsdf 0022 0023 <span style="color:#fdbc4b;font-weight:bold;">if</span> sldfjsdj <span style="color:#fdbc4b;font-weight:bold;">then</span> 0024 <span style="color:#fdbc4b;font-weight:bold;">case</span> 0025 <span style="color:#fdbc4b;font-weight:bold;">when</span> <span style="color:#f67400;">1</span><span style="color:#3f8058;">=</span><span style="color:#f67400;">1</span> <span style="color:#fdbc4b;font-weight:bold;">then</span> 0026 aslfjsldkfj; 0027 <span style="color:#fdbc4b;font-weight:bold;">when</span> <span style="color:#f67400;">2</span><span style="color:#3f8058;">=</span><span style="color:#f67400;">2</span> <span style="color:#fdbc4b;font-weight:bold;">then</span> 0028 asdfg; 0029 <span style="color:#fdbc4b;font-weight:bold;">else</span> 0030 <span style="font-weight:bold;">null</span>; 0031 <span style="color:#fdbc4b;font-weight:bold;">end case</span>; 0032 0033 <span style="color:#fdbc4b;font-weight:bold;">if</span> sdfjh <span style="color:#fdbc4b;font-weight:bold;">then</span> 0034 <span style="color:#fdbc4b;font-weight:bold;">for</span> i <span style="font-weight:bold;">in</span> <span style="color:#f67400;">1</span> <span style="color:#3f8058;">..</span> <span style="color:#f67400;">2</span> 0035 <span style="color:#fdbc4b;font-weight:bold;">LOOP</span> 0036 dbms_output.put_line(<span style="color:#3f8058;">q';</span><span style="color:#f44f4f;">ololo</span><span style="color:#3f8058;">;'</span>); 0037 <span style="color:#fdbc4b;font-weight:bold;">END Loop</span>; 0038 0039 <span style="color:#fdbc4b;font-weight:bold;">while</span> <span style="font-weight:bold;">true</span> 0040 <span style="color:#fdbc4b;font-weight:bold;">loop</span> 0041 dbms_output.put_line(<span style="color:#f44f4f;">'1111'</span>); 0042 <span style="color:#fdbc4b;font-weight:bold;">end loop</span>; 0043 <span style="color:#fdbc4b;font-weight:bold;">end if</span>; 0044 ksjfklasjd; 0045 fklj; 0046 <span style="color:#fdbc4b;font-weight:bold;">elsif</span> 0047 sdklfjsdklfj; 0048 <span style="color:#fdbc4b;font-weight:bold;">else</span> 0049 sdfdfsdf; 0050 <span style="color:#fdbc4b;font-weight:bold;">end if</span>; 0051 <span style="color:#fdbc4b;font-weight:bold;">end</span>; 0052 0053 <span style="font-weight:bold;">CREATE</span> <span style="font-weight:bold;">TABLE</span> Persons ( 0054 <span style="font-weight:bold;">ID</span> <span style="color:#2980b9;">int</span> <span style="font-weight:bold;">NOT</span> <span style="font-weight:bold;">NULL</span>, 0055 LastName <span style="color:#2980b9;">varchar</span>(<span style="color:#f67400;">255</span>) <span style="font-weight:bold;">NOT</span> <span style="font-weight:bold;">NULL</span>, 0056 FirstName <span style="color:#2980b9;">varchar</span>(<span style="color:#f67400;">255</span>), 0057 Age <span style="color:#2980b9;">int</span>, 0058 City <span style="color:#2980b9;">varchar</span>(<span style="color:#f67400;">255</span>), 0059 <span style="font-weight:bold;">CONSTRAINT</span> CHK_Person <span style="font-weight:bold;">CHECK</span> (Age<span style="color:#3f8058;">>=</span><span style="color:#f67400;">18</span> <span style="font-weight:bold;">AND</span> City<span style="color:#3f8058;">=</span><span style="color:#f44f4f;">'Sandnes'</span>) 0060 ); 0061 </pre></body></html>