Debian Codegraph @

autotests/html/test.sql_oracle.html

raw
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 Light)"/>
6 </head><body style="background-color:#ffffff;color:#1f1c1b"><pre>
7 <span style="color:#898887;">-- </span><span style="color:#ca60ca;">kate:</span><span style="color:#898887;"> </span><span style="color:#0095ff;">hl</span><span style="color:#bf0303;"> SQL (Oracle)</span>
8 <span style="color:#898887;">-- test case shipped with highlighting in bugzilla, LGPL</span>
9
10 <span style="font-weight:bold;">declare</span>
11 v_nchar <span style="color:#0057ae;">NCHAR</span>(<span style="color:#b08000;">12</span>);
12 <span style="font-weight:bold;">begin</span>
13 <span style="color:#ca60ca;">q'{</span><span style="color:#bf0303;">adfasdf'sadfasdf j</span><span style="color:#ca60ca;">}'</span>{<span style="color:#bf0303;">' hkjhkhkjhkjh khlkhklj'</span>fghdfghdfgh<span style="color:#bf0303;">'hkjh'</span>jkhkh<span style="color:#bf0303;">'a'</span>
14 <span style="color:#ca60ca;">nQ'(</span><span style="color:#bf0303;">asldflahsl;'dkjfhklsdfh</span><span style="color:#ca60ca;">)'</span>
15 <span style="color:#ca60ca;">Nq'[</span><span style="color:#bf0303;">asdasd;'asdasd'a]sd'asd'asasd</span><span style="color:#ca60ca;">]'</span>;<span style="color:#b08000;">11111111</span>[<span style="color:#b08000;">1</span><span style="color:#bf0303;">']; asdasdasdasd'</span>errrrrrrrrrrrrrr<span style="color:#ca60ca;">-</span>p
16
17 <span style="color:#ca60ca;">nq'a</span><span style="color:#bf0303;">gdfgsdfgfhfghjfgh'f'f'sdfg'sdfg'dfg#</span><span style="color:#ca60ca;">a'</span> dafdfadasfasdf;
18 v_nchar <span style="color:#ca60ca;">:=</span> <span style="color:#ca60ca;">n'</span><span style="color:#bf0303;">NCHAR STRING'</span>;
19 if_n <span style="color:#ca60ca;">:=</span> <span style="color:#b08000;">0</span>;
20
21 <span style="color:#ca60ca;">Q'#</span><span style="color:#bf0303;">gdfgsdfgsdfgsdfgsdfg</span><span style="color:#ca60ca;">#'</span> afgasasdfasdfasfasdfasdfasdfasdfsdf
22
23 <span style="font-weight:bold;">if</span> sldfjsdj <span style="font-weight:bold;">then</span>
24 <span style="font-weight:bold;">case</span>
25 <span style="font-weight:bold;">when</span> <span style="color:#b08000;">1</span><span style="color:#ca60ca;">=</span><span style="color:#b08000;">1</span> <span style="font-weight:bold;">then</span>
26 aslfjsldkfj;
27 <span style="font-weight:bold;">when</span> <span style="color:#b08000;">2</span><span style="color:#ca60ca;">=</span><span style="color:#b08000;">2</span> <span style="font-weight:bold;">then</span>
28 asdfg;
29 <span style="font-weight:bold;">else</span>
30 <span style="font-weight:bold;">null</span>;
31 <span style="font-weight:bold;">end case</span>;
32
33 <span style="font-weight:bold;">if</span> sdfjh <span style="font-weight:bold;">then</span>
34 <span style="font-weight:bold;">for</span> i <span style="font-weight:bold;">in</span> <span style="color:#b08000;">1</span> <span style="color:#ca60ca;">..</span> <span style="color:#b08000;">2</span>
35 <span style="font-weight:bold;">LOOP</span>
36 dbms_output.put_line(<span style="color:#ca60ca;">q';</span><span style="color:#bf0303;">ololo</span><span style="color:#ca60ca;">;'</span>);
37 <span style="font-weight:bold;">END Loop</span>;
38
39 <span style="font-weight:bold;">while</span> <span style="font-weight:bold;">true</span>
40 <span style="font-weight:bold;">loop</span>
41 dbms_output.put_line(<span style="color:#bf0303;">'1111'</span>);
42 <span style="font-weight:bold;">end loop</span>;
43 <span style="font-weight:bold;">end if</span>;
44 ksjfklasjd;
45 fklj;
46 <span style="font-weight:bold;">elsif</span>
47 sdklfjsdklfj;
48 <span style="font-weight:bold;">else</span>
49 sdfdfsdf;
50 <span style="font-weight:bold;">end if</span>;
51 <span style="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:#0057ae;">int</span> <span style="font-weight:bold;">NOT</span> <span style="font-weight:bold;">NULL</span>,
55 LastName <span style="color:#0057ae;">varchar</span>(<span style="color:#b08000;">255</span>) <span style="font-weight:bold;">NOT</span> <span style="font-weight:bold;">NULL</span>,
56 FirstName <span style="color:#0057ae;">varchar</span>(<span style="color:#b08000;">255</span>),
57 Age <span style="color:#0057ae;">int</span>,
58 City <span style="color:#0057ae;">varchar</span>(<span style="color:#b08000;">255</span>),
59 <span style="font-weight:bold;">CONSTRAINT</span> CHK_Person <span style="font-weight:bold;">CHECK</span> (Age<span style="color:#ca60ca;">&gt;=</span><span style="color:#b08000;">18</span> <span style="font-weight:bold;">AND</span> City<span style="color:#ca60ca;">=</span><span style="color:#bf0303;">'Sandnes'</span>)
60 );
61 </pre></body></html>