Differential D11470 Diff 32855 autotests/html/test.sql_oracle.html

Changeset View

Standalone View

View Options

autotests/html/test.sql_oracle.html

1<!DOCTYPE html> 1​<!DOCTYPE html>
2<html><head> 2​<html><head>
3<meta http-equiv="Content-Type" content="text/html; charset=UTF-8"/> 3​<meta http-equiv="Content-Type" content="text/html; charset=UTF-8"/>
4<title>test.sql_oracle</title> 4​<title>test.sql_oracle</title>
5<meta name="generator" content="KF5::SyntaxHighlighting (SQL (Oracle))"/> 5​<meta name="generator" content="KF5::SyntaxHighlighting (SQL (Oracle))"/>
6</head><body style="color:#1f1c1b"><pre> 6​</head><body style="color:#1f1c1b"><pre>
7<span style="color:#898887;">-- kate: hl SQL (Oracle)</span> 7​<span style="color:#898887;">-- kate: hl SQL (Oracle)</span>
8<span style="color:#898887;">-- test case shipped with highlighting in bugzilla, LGPL</span> 8​<span style="color:#898887;">-- test case shipped with highlighting in bugzilla, LGPL</span>
9 9​
10<span style="font-weight:bold;">declare</span> 10​<span style="font-weight:bold;">declare</span>
11 v_nchar <span style="color:#0057ae;">NCHAR</span>(<span style="color:#b08000;">12</span>); 11​ v_nchar <span style="color:#0057ae;">NCHAR</span>(<span style="color:#b08000;">12</span>);
12<span style="font-weight:bold;">begin</span> 12​<span style="font-weight:bold;">begin</span>
13 q'{<span style="color:#bf0303;">adfasdf'sadfasdf j</span>}'{<span style="color:#bf0303;">' hkjhkhkjhkjh khlkhklj'</span>fghdfghdfgh<span style="color:#bf0303;">'hkjh'</span>jkhkh<span style="color:#bf0303;">'a'</span> 13​ q'{<span style="color:#bf0303;">adfasdf'sadfasdf j</span>}'{<span style="color:#bf0303;">' hkjhkhkjhkjh khlkhklj'</span>fghdfghdfgh<span style="color:#bf0303;">'hkjh'</span>jkhkh<span style="color:#bf0303;">'a'</span>
14 nQ'(<span style="color:#bf0303;">asldflahsl;'dkjfhklsdfh</span>)' 14​ nQ'(<span style="color:#bf0303;">asldflahsl;'dkjfhklsdfh</span>)'
15 Nq'[<span style="color:#bf0303;">asdasd;'asdasd'a]sd'asd'asasd</span>]';11111111[<span style="color:#b08000;">1</span><span style="color:#bf0303;">']; asdasdasdasd'</span>errrrrrrrrrrrrrr-p 15​ Nq'[<span style="color:#bf0303;">asdasd;'asdasd'a]sd'asd'asasd</span>]';<span style="color:#b08000;">11111111</span>[<span style="color:#b08000;">1</span><span style="color:#bf0303;">']; asdasdasdasd'</span>errrrrrrrrrrrrrr-p
16 16​
17 nq'a<span style="color:#bf0303;">gdfgsdfgfhfghjfgh'f'f'sdfg'sdfg'dfg#</span>a' dafdfadasfasdf; 17​ nq'a<span style="color:#bf0303;">gdfgsdfgfhfghjfgh'f'f'sdfg'sdfg'dfg#</span>a' dafdfadasfasdf;
18 v_nchar := n'<span style="color:#bf0303;">NCHAR STRING'</span>; 18​ v_nchar := n'<span style="color:#bf0303;">NCHAR STRING'</span>;
19​ if_n := <span style="color:#b08000;">0</span>;
19 20​
20 Q'#<span style="color:#bf0303;">gdfgsdfgsdfgsdfgsdfg</span>#' afgasasdfasdfasfasdfasdfasdfasdfsdf 21​ Q'#<span style="color:#bf0303;">gdfgsdfgsdfgsdfgsdfg</span>#' afgasasdfasdfasfasdfasdfasdfasdfsdf
21 22​
22 <span style="font-weight:bold;">if</span> sldfjsdj <span style="font-weight:bold;">then</span> 23​ <span style="font-weight:bold;">if</span> sldfjsdj <span style="font-weight:bold;">then</span>
23 <span style="font-weight:bold;">case</span> 24​ <span style="font-weight:bold;">case</span>
24 <span style="font-weight:bold;">when</span> <span style="color:#b08000;">1</span>=1 <span style="font-weight:bold;">then</span> 25​ <span style="font-weight:bold;">when</span> <span style="color:#b08000;">1</span>=<span style="color:#b08000;">1</span> <span style="font-weight:bold;">then</span>
25 aslfjsldkfj; 26​ aslfjsldkfj;
26 <span style="font-weight:bold;">when</span> <span style="color:#b08000;">2</span>=2 <span style="font-weight:bold;">then</span> 27​ <span style="font-weight:bold;">when</span> <span style="color:#b08000;">2</span>=<span style="color:#b08000;">2</span> <span style="font-weight:bold;">then</span>
27 asdfg; 28​ asdfg;
28 <span style="font-weight:bold;">else</span> 29​ <span style="font-weight:bold;">else</span>
29 null; 30​ <span style="font-weight:bold;">null</span>;
30 <span style="font-weight:bold;">end case</span>; 31​ <span style="font-weight:bold;">end case</span>;
31 32​
32 <span style="font-weight:bold;">if</span> sdfjh <span style="font-weight:bold;">then</span> 33​ <span style="font-weight:bold;">if</span> sdfjh <span style="font-weight:bold;">then</span>
33 <span style="font-weight:bold;">for</span> i <span style="font-weight:bold;">in</span> <span style="color:#b08000;">1</span> .. <span style="color:#b08000;">2</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:#b08000;">2</span>
34 <span style="font-weight:bold;">LOOP</span> 35​ <span style="font-weight:bold;">LOOP</span>
35 dbms_output.put_line(q';<span style="color:#bf0303;">ololo</span>;'); 36​ dbms_output.put_line(q';<span style="color:#bf0303;">ololo</span>;');
36 <span style="font-weight:bold;">END Loop</span>; 37​ <span style="font-weight:bold;">END Loop</span>;
37 38​
38 <span style="font-weight:bold;">while</span> <span style="font-weight:bold;">true</span> 39​ <span style="font-weight:bold;">while</span> <span style="font-weight:bold;">true</span>
39 <span style="font-weight:bold;">loop</span> 40​ <span style="font-weight:bold;">loop</span>
40 dbms_output.put_line(<span style="color:#bf0303;">'1111'</span>); 41​ dbms_output.put_line(<span style="color:#bf0303;">'1111'</span>);
41 <span style="font-weight:bold;">end loop</span>; 42​ <span style="font-weight:bold;">end loop</span>;
42 <span style="font-weight:bold;">end if</span>; 43​ <span style="font-weight:bold;">end if</span>;
43 ksjfklasjd; 44​ ksjfklasjd;
44 fklj; 45​ fklj;
45 <span style="font-weight:bold;">elsif</span> 46​ <span style="font-weight:bold;">elsif</span>
46 sdklfjsdklfj; 47​ sdklfjsdklfj;
47 <span style="font-weight:bold;">else</span> 48​ <span style="font-weight:bold;">else</span>
48 sdfdfsdf; 49​ sdfdfsdf;
49 <span style="font-weight:bold;">end if</span>; 50​ <span style="font-weight:bold;">end if</span>;
50<span style="font-weight:bold;">end</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&gt;=<span style="color:#b08000;">18</span> <span style="font-weight:bold;">AND</span> City=<span style="color:#bf0303;">'Sandnes'</span>)
60​);
51</pre></body></html> 61​</pre></body></html>