| 1 |
<!DOCTYPE html> |
| 2 |
<html><head> |
| 3 |
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8"/> |
| 4 |
<title>test.sql_oracle</title> |
| 5 |
<meta name="generator" content="KF5::SyntaxHighlighting - Definition (SQL (Oracle)) - Theme (Breeze Dark)"/> |
| 6 |
</head><body style="background-color:#232629;color:#cfcfc2"><pre> |
| 7 |
<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> |
| 8 |
<span style="color:#7a7c7d;">-- test case shipped with highlighting in bugzilla, LGPL</span> |
| 9 |
|
| 10 |
<span style="font-weight:bold;">declare</span> |
| 11 |
v_nchar <span style="color:#2980b9;">NCHAR</span>(<span style="color:#f67400;">12</span>); |
| 12 |
<span style="color:#fdbc4b;font-weight:bold;">begin</span> |
| 13 |
<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> |
| 14 |
<span style="color:#3f8058;">nQ'(</span><span style="color:#f44f4f;">asldflahsl;'dkjfhklsdfh</span><span style="color:#3f8058;">)'</span> |
| 15 |
<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 |
| 16 |
|
| 17 |
<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; |
| 18 |
v_nchar <span style="color:#3f8058;">:=</span> <span style="color:#3f8058;">n'</span><span style="color:#f44f4f;">NCHAR STRING'</span>; |
| 19 |
if_n <span style="color:#3f8058;">:=</span> <span style="color:#f67400;">0</span>; |
| 20 |
|
| 21 |
<span style="color:#3f8058;">Q'#</span><span style="color:#f44f4f;">gdfgsdfgsdfgsdfgsdfg</span><span style="color:#3f8058;">#'</span> afgasasdfasdfasfasdfasdfasdfasdfsdf |
| 22 |
|
| 23 |
<span style="color:#fdbc4b;font-weight:bold;">if</span> sldfjsdj <span style="color:#fdbc4b;font-weight:bold;">then</span> |
| 24 |
<span style="color:#fdbc4b;font-weight:bold;">case</span> |
| 25 |
<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> |
| 26 |
aslfjsldkfj; |
| 27 |
<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> |
| 28 |
asdfg; |
| 29 |
<span style="color:#fdbc4b;font-weight:bold;">else</span> |
| 30 |
<span style="font-weight:bold;">null</span>; |
| 31 |
<span style="color:#fdbc4b;font-weight:bold;">end case</span>; |
| 32 |
|
| 33 |
<span style="color:#fdbc4b;font-weight:bold;">if</span> sdfjh <span style="color:#fdbc4b;font-weight:bold;">then</span> |
| 34 |
<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> |
| 35 |
<span style="color:#fdbc4b;font-weight:bold;">LOOP</span> |
| 36 |
dbms_output.put_line(<span style="color:#3f8058;">q';</span><span style="color:#f44f4f;">ololo</span><span style="color:#3f8058;">;'</span>); |
| 37 |
<span style="color:#fdbc4b;font-weight:bold;">END Loop</span>; |
| 38 |
|
| 39 |
<span style="color:#fdbc4b;font-weight:bold;">while</span> <span style="font-weight:bold;">true</span> |
| 40 |
<span style="color:#fdbc4b;font-weight:bold;">loop</span> |
| 41 |
dbms_output.put_line(<span style="color:#f44f4f;">'1111'</span>); |
| 42 |
<span style="color:#fdbc4b;font-weight:bold;">end loop</span>; |
| 43 |
<span style="color:#fdbc4b;font-weight:bold;">end if</span>; |
| 44 |
ksjfklasjd; |
| 45 |
fklj; |
| 46 |
<span style="color:#fdbc4b;font-weight:bold;">elsif</span> |
| 47 |
sdklfjsdklfj; |
| 48 |
<span style="color:#fdbc4b;font-weight:bold;">else</span> |
| 49 |
sdfdfsdf; |
| 50 |
<span style="color:#fdbc4b;font-weight:bold;">end if</span>; |
| 51 |
<span style="color:#fdbc4b;font-weight:bold;">end</span>; |
| 52 |
|
| 53 |
<span style="font-weight:bold;">CREATE</span> <span style="font-weight:bold;">TABLE</span> Persons ( |
| 54 |
<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>, |
| 55 |
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>, |
| 56 |
FirstName <span style="color:#2980b9;">varchar</span>(<span style="color:#f67400;">255</span>), |
| 57 |
Age <span style="color:#2980b9;">int</span>, |
| 58 |
City <span style="color:#2980b9;">varchar</span>(<span style="color:#f67400;">255</span>), |
| 59 |
<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>) |
| 60 |
); |
| 61 |
</pre></body></html> |