Changeset View
Changeset View
Standalone View
Standalone View
autotests/reference/test.sql_oracle.ref
1 | <Comment>-- kate: hl SQL (Oracle)</Comment><br/> | 1 | <Comment>-- kate: hl SQL (Oracle)</Comment><br/> | ||
---|---|---|---|---|---|
2 | <Comment>-- test case shipped with highlighting in bugzilla, LGPL</Comment><br/> | 2 | <Comment>-- test case shipped with highlighting in bugzilla, LGPL</Comment><br/> | ||
3 | <dsNormal></dsNormal><br/> | 3 | <dsNormal></dsNormal><br/> | ||
4 | <Keyword>declare</Keyword><br/> | 4 | <Keyword>declare</Keyword><br/> | ||
5 | <Normal Text> v_nchar </Normal Text><Data Type>NCHAR</Data Type><Normal Text>(</Normal Text><Number>12</Number><Normal Text>);</Normal Text><br/> | 5 | <Normal Text> v_nchar </Normal Text><Data Type>NCHAR</Data Type><Normal Text>(</Normal Text><Number>12</Number><Normal Text>);</Normal Text><br/> | ||
6 | <Keyword>begin</Keyword><br/> | 6 | <ControlFlow>begin</ControlFlow><br/> | ||
7 | <Normal Text> </Normal Text><Operator>q'{</Operator><String>adfasdf'sadfasdf j</String><Operator>}'</Operator><Normal Text>{</Normal Text><String>' hkjhkhkjhkjh khlkhklj'</String><Normal Text>fghdfghdfgh</Normal Text><String>'hkjh'</String><Normal Text>jkhkh</Normal Text><String>'a'</String><br/> | 7 | <Normal Text> </Normal Text><Operator>q'{</Operator><String>adfasdf'sadfasdf j</String><Operator>}'</Operator><Normal Text>{</Normal Text><String>' hkjhkhkjhkjh khlkhklj'</String><Normal Text>fghdfghdfgh</Normal Text><String>'hkjh'</String><Normal Text>jkhkh</Normal Text><String>'a'</String><br/> | ||
8 | <Normal Text> </Normal Text><Operator>nQ'(</Operator><String>asldflahsl;'dkjfhklsdfh</String><Operator>)'</Operator><br/> | 8 | <Normal Text> </Normal Text><Operator>nQ'(</Operator><String>asldflahsl;'dkjfhklsdfh</String><Operator>)'</Operator><br/> | ||
9 | <Normal Text> </Normal Text><Operator>Nq'[</Operator><String>asdasd;'asdasd'a]sd'asd'asasd</String><Operator>]'</Operator><Normal Text>;11111111[</Normal Text><Number>1</Number><String>']; asdasdasdasd'</String><Normal Text>errrrrrrrrrrrrrr-p</Normal Text><br/> | 9 | <Normal Text> </Normal Text><Operator>Nq'[</Operator><String>asdasd;'asdasd'a]sd'asd'asasd</String><Operator>]'</Operator><Normal Text>;</Normal Text><Number>11111111</Number><Normal Text>[</Normal Text><Number>1</Number><String>']; asdasdasdasd'</String><Normal Text>errrrrrrrrrrrrrr</Normal Text><Operator>-</Operator><Normal Text>p</Normal Text><br/> | ||
10 | <dsNormal></dsNormal><br/> | 10 | <dsNormal></dsNormal><br/> | ||
11 | <Normal Text> </Normal Text><Operator>nq'a</Operator><String>gdfgsdfgfhfghjfgh'f'f'sdfg'sdfg'dfg#</String><Operator>a'</Operator><Normal Text> dafdfadasfasdf;</Normal Text><br/> | 11 | <Normal Text> </Normal Text><Operator>nq'a</Operator><String>gdfgsdfgfhfghjfgh'f'f'sdfg'sdfg'dfg#</String><Operator>a'</Operator><Normal Text> dafdfadasfasdf;</Normal Text><br/> | ||
12 | <Normal Text> v_nchar </Normal Text><Operator>:=</Operator><Normal Text> </Normal Text><Operator>n'</Operator><String>NCHAR STRING'</String><Normal Text>;</Normal Text><br/> | 12 | <Normal Text> v_nchar </Normal Text><Operator>:=</Operator><Normal Text> </Normal Text><Operator>n'</Operator><String>NCHAR STRING'</String><Normal Text>;</Normal Text><br/> | ||
13 | <Normal Text> if_n </Normal Text><Operator>:=</Operator><Normal Text> </Normal Text><Number>0</Number><Normal Text>;</Normal Text><br/> | ||||
13 | <dsNormal></dsNormal><br/> | 14 | <dsNormal></dsNormal><br/> | ||
14 | <Normal Text> </Normal Text><Operator>Q'#</Operator><String>gdfgsdfgsdfgsdfgsdfg</String><Operator>#'</Operator><Normal Text> afgasasdfasdfasfasdfasdfasdfasdfsdf</Normal Text><br/> | 15 | <Normal Text> </Normal Text><Operator>Q'#</Operator><String>gdfgsdfgsdfgsdfgsdfg</String><Operator>#'</Operator><Normal Text> afgasasdfasdfasfasdfasdfasdfasdfsdf</Normal Text><br/> | ||
15 | <dsNormal></dsNormal><br/> | 16 | <dsNormal></dsNormal><br/> | ||
16 | <Normal Text> </Normal Text><Keyword>if</Keyword><Normal Text> sldfjsdj </Normal Text><Keyword>then</Keyword><br/> | 17 | <Normal Text> </Normal Text><ControlFlow>if</ControlFlow><Normal Text> sldfjsdj </Normal Text><ControlFlow>then</ControlFlow><br/> | ||
17 | <Normal Text> </Normal Text><Keyword>case</Keyword><br/> | 18 | <Normal Text> </Normal Text><ControlFlow>case</ControlFlow><br/> | ||
18 | <Normal Text> </Normal Text><Keyword>when</Keyword><Normal Text> </Normal Text><Number>1</Number><Normal Text>=1 </Normal Text><Keyword>then</Keyword><br/> | 19 | <Normal Text> </Normal Text><ControlFlow>when</ControlFlow><Normal Text> </Normal Text><Number>1</Number><Operator>=</Operator><Number>1</Number><Normal Text> </Normal Text><ControlFlow>then</ControlFlow><br/> | ||
19 | <Normal Text> aslfjsldkfj;</Normal Text><br/> | 20 | <Normal Text> aslfjsldkfj;</Normal Text><br/> | ||
20 | <Normal Text> </Normal Text><Keyword>when</Keyword><Normal Text> </Normal Text><Number>2</Number><Normal Text>=2 </Normal Text><Keyword>then</Keyword><br/> | 21 | <Normal Text> </Normal Text><ControlFlow>when</ControlFlow><Normal Text> </Normal Text><Number>2</Number><Operator>=</Operator><Number>2</Number><Normal Text> </Normal Text><ControlFlow>then</ControlFlow><br/> | ||
21 | <Normal Text> asdfg;</Normal Text><br/> | 22 | <Normal Text> asdfg;</Normal Text><br/> | ||
22 | <Normal Text> </Normal Text><Keyword>else</Keyword><br/> | 23 | <Normal Text> </Normal Text><ControlFlow>else</ControlFlow><br/> | ||
23 | <Normal Text> null;</Normal Text><br/> | 24 | <Normal Text> </Normal Text><Keyword>null</Keyword><Normal Text>;</Normal Text><br/> | ||
24 | <Normal Text> </Normal Text><Keyword>end case</Keyword><Normal Text>;</Normal Text><br/> | 25 | <Normal Text> </Normal Text><ControlFlow>end case</ControlFlow><Normal Text>;</Normal Text><br/> | ||
25 | <dsNormal></dsNormal><br/> | 26 | <dsNormal></dsNormal><br/> | ||
26 | <Normal Text> </Normal Text><Keyword>if</Keyword><Normal Text> sdfjh </Normal Text><Keyword>then</Keyword><br/> | 27 | <Normal Text> </Normal Text><ControlFlow>if</ControlFlow><Normal Text> sdfjh </Normal Text><ControlFlow>then</ControlFlow><br/> | ||
27 | <Normal Text> </Normal Text><Keyword>for</Keyword><Normal Text> i </Normal Text><Keyword>in</Keyword><Normal Text> </Normal Text><Number>1</Number><Normal Text> </Normal Text><Operator>..</Operator><Normal Text> </Normal Text><Number>2</Number><br/> | 28 | <Normal Text> </Normal Text><ControlFlow>for</ControlFlow><Normal Text> i </Normal Text><Operator Keyword>in</Operator Keyword><Normal Text> </Normal Text><Number>1</Number><Normal Text> </Normal Text><Operator>..</Operator><Normal Text> </Normal Text><Number>2</Number><br/> | ||
28 | <Normal Text> </Normal Text><Keyword>LOOP</Keyword><br/> | 29 | <Normal Text> </Normal Text><ControlFlow>LOOP</ControlFlow><br/> | ||
29 | <Normal Text> dbms_output.put_line(</Normal Text><Operator>q';</Operator><String>ololo</String><Operator>;'</Operator><Normal Text>);</Normal Text><br/> | 30 | <Normal Text> dbms_output.put_line(</Normal Text><Operator>q';</Operator><String>ololo</String><Operator>;'</Operator><Normal Text>);</Normal Text><br/> | ||
30 | <Normal Text> </Normal Text><Keyword>END Loop</Keyword><Normal Text>;</Normal Text><br/> | 31 | <Normal Text> </Normal Text><ControlFlow>END Loop</ControlFlow><Normal Text>;</Normal Text><br/> | ||
31 | <dsNormal></dsNormal><br/> | 32 | <dsNormal></dsNormal><br/> | ||
32 | <Normal Text> </Normal Text><Keyword>while</Keyword><Normal Text> </Normal Text><Keyword>true</Keyword><br/> | 33 | <Normal Text> </Normal Text><ControlFlow>while</ControlFlow><Normal Text> </Normal Text><Keyword>true</Keyword><br/> | ||
33 | <Normal Text> </Normal Text><Keyword>loop</Keyword><br/> | 34 | <Normal Text> </Normal Text><ControlFlow>loop</ControlFlow><br/> | ||
34 | <Normal Text> dbms_output.put_line(</Normal Text><String>'1111'</String><Normal Text>);</Normal Text><br/> | 35 | <Normal Text> dbms_output.put_line(</Normal Text><String>'1111'</String><Normal Text>);</Normal Text><br/> | ||
35 | <Normal Text> </Normal Text><Keyword>end loop</Keyword><Normal Text>;</Normal Text><br/> | 36 | <Normal Text> </Normal Text><ControlFlow>end loop</ControlFlow><Normal Text>;</Normal Text><br/> | ||
36 | <Normal Text> </Normal Text><Keyword>end if</Keyword><Normal Text>;</Normal Text><br/> | 37 | <Normal Text> </Normal Text><ControlFlow>end if</ControlFlow><Normal Text>;</Normal Text><br/> | ||
37 | <Normal Text> ksjfklasjd;</Normal Text><br/> | 38 | <Normal Text> ksjfklasjd;</Normal Text><br/> | ||
38 | <Normal Text> fklj;</Normal Text><br/> | 39 | <Normal Text> fklj;</Normal Text><br/> | ||
39 | <Normal Text> </Normal Text><Keyword>elsif</Keyword><br/> | 40 | <Normal Text> </Normal Text><ControlFlow>elsif</ControlFlow><br/> | ||
40 | <Normal Text> sdklfjsdklfj;</Normal Text><br/> | 41 | <Normal Text> sdklfjsdklfj;</Normal Text><br/> | ||
41 | <Normal Text> </Normal Text><Keyword>else</Keyword><br/> | 42 | <Normal Text> </Normal Text><ControlFlow>else</ControlFlow><br/> | ||
42 | <Normal Text> sdfdfsdf;</Normal Text><br/> | 43 | <Normal Text> sdfdfsdf;</Normal Text><br/> | ||
43 | <Normal Text> </Normal Text><Keyword>end if</Keyword><Normal Text>;</Normal Text><br/> | 44 | <Normal Text> </Normal Text><ControlFlow>end if</ControlFlow><Normal Text>;</Normal Text><br/> | ||
44 | <Keyword>end</Keyword><Normal Text>;</Normal Text><br/> | 45 | <ControlFlow>end</ControlFlow><Normal Text>;</Normal Text><br/> | ||
46 | <dsNormal></dsNormal><br/> | ||||
47 | <Keyword>CREATE</Keyword><Normal Text> </Normal Text><Keyword>TABLE</Keyword><Normal Text> Persons (</Normal Text><br/> | ||||
48 | <Normal Text> </Normal Text><Keyword>ID</Keyword><Normal Text> </Normal Text><Data Type>int</Data Type><Normal Text> </Normal Text><Operator Keyword>NOT</Operator Keyword><Normal Text> </Normal Text><Keyword>NULL</Keyword><Normal Text>,</Normal Text><br/> | ||||
49 | <Normal Text> LastName </Normal Text><Data Type>varchar</Data Type><Normal Text>(</Normal Text><Number>255</Number><Normal Text>) </Normal Text><Operator Keyword>NOT</Operator Keyword><Normal Text> </Normal Text><Keyword>NULL</Keyword><Normal Text>,</Normal Text><br/> | ||||
50 | <Normal Text> FirstName </Normal Text><Data Type>varchar</Data Type><Normal Text>(</Normal Text><Number>255</Number><Normal Text>),</Normal Text><br/> | ||||
51 | <Normal Text> Age </Normal Text><Data Type>int</Data Type><Normal Text>,</Normal Text><br/> | ||||
52 | <Normal Text> City </Normal Text><Data Type>varchar</Data Type><Normal Text>(</Normal Text><Number>255</Number><Normal Text>),</Normal Text><br/> | ||||
53 | <Normal Text> </Normal Text><Keyword>CONSTRAINT</Keyword><Normal Text> CHK_Person </Normal Text><Keyword>CHECK</Keyword><Normal Text> (Age</Normal Text><Operator>>=</Operator><Number>18</Number><Normal Text> </Normal Text><Operator Keyword>AND</Operator Keyword><Normal Text> City</Normal Text><Operator>=</Operator><String>'Sandnes'</String><Normal Text>)</Normal Text><br/> | ||||
54 | <Normal Text>);</Normal Text><br/> |