Warning, /frameworks/syntax-highlighting/autotests/reference/test.sql_oracle.ref is written in an unsupported language. File is not indexed.
0001 <Comment>-- </Comment><Keyword>kate:</Keyword><Comment> </Comment><Variable>hl</Variable><String> SQL (Oracle)</String><br/>
0002 <Comment>-- test case shipped with highlighting in bugzilla, LGPL</Comment><br/>
0003 <Normal Text></Normal Text><br/>
0004 <Keyword>declare</Keyword><br/>
0005 <Normal Text> v_nchar </Normal Text><Data Type>NCHAR</Data Type><Normal Text>(</Normal Text><Number>12</Number><Normal Text>);</Normal Text><br/>
0006 <ControlFlow>begin</ControlFlow><br/>
0007 <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/>
0008 <Normal Text> </Normal Text><Operator>nQ'(</Operator><String>asldflahsl;'dkjfhklsdfh</String><Operator>)'</Operator><br/>
0009 <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/>
0010 <Normal Text></Normal Text><br/>
0011 <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/>
0012 <Normal Text> v_nchar </Normal Text><Operator>:=</Operator><Normal Text> </Normal Text><Operator>n'</Operator><String>NCHAR STRING'</String><Normal Text>;</Normal Text><br/>
0013 <Normal Text> if_n </Normal Text><Operator>:=</Operator><Normal Text> </Normal Text><Number>0</Number><Normal Text>;</Normal Text><br/>
0014 <Normal Text></Normal Text><br/>
0015 <Normal Text> </Normal Text><Operator>Q'#</Operator><String>gdfgsdfgsdfgsdfgsdfg</String><Operator>#'</Operator><Normal Text> afgasasdfasdfasfasdfasdfasdfasdfsdf</Normal Text><br/>
0016 <Normal Text></Normal Text><br/>
0017 <Normal Text> </Normal Text><ControlFlow>if</ControlFlow><Normal Text> sldfjsdj </Normal Text><ControlFlow>then</ControlFlow><br/>
0018 <Normal Text> </Normal Text><ControlFlow>case</ControlFlow><br/>
0019 <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/>
0020 <Normal Text> aslfjsldkfj;</Normal Text><br/>
0021 <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/>
0022 <Normal Text> asdfg;</Normal Text><br/>
0023 <Normal Text> </Normal Text><ControlFlow>else</ControlFlow><br/>
0024 <Normal Text> </Normal Text><Keyword>null</Keyword><Normal Text>;</Normal Text><br/>
0025 <Normal Text> </Normal Text><ControlFlow>end case</ControlFlow><Normal Text>;</Normal Text><br/>
0026 <Normal Text></Normal Text><br/>
0027 <Normal Text> </Normal Text><ControlFlow>if</ControlFlow><Normal Text> sdfjh </Normal Text><ControlFlow>then</ControlFlow><br/>
0028 <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/>
0029 <Normal Text> </Normal Text><ControlFlow>LOOP</ControlFlow><br/>
0030 <Normal Text> dbms_output.put_line(</Normal Text><Operator>q';</Operator><String>ololo</String><Operator>;'</Operator><Normal Text>);</Normal Text><br/>
0031 <Normal Text> </Normal Text><ControlFlow>END Loop</ControlFlow><Normal Text>;</Normal Text><br/>
0032 <Normal Text></Normal Text><br/>
0033 <Normal Text> </Normal Text><ControlFlow>while</ControlFlow><Normal Text> </Normal Text><Keyword>true</Keyword><br/>
0034 <Normal Text> </Normal Text><ControlFlow>loop</ControlFlow><br/>
0035 <Normal Text> dbms_output.put_line(</Normal Text><String>'1111'</String><Normal Text>);</Normal Text><br/>
0036 <Normal Text> </Normal Text><ControlFlow>end loop</ControlFlow><Normal Text>;</Normal Text><br/>
0037 <Normal Text> </Normal Text><ControlFlow>end if</ControlFlow><Normal Text>;</Normal Text><br/>
0038 <Normal Text> ksjfklasjd;</Normal Text><br/>
0039 <Normal Text> fklj;</Normal Text><br/>
0040 <Normal Text> </Normal Text><ControlFlow>elsif</ControlFlow><br/>
0041 <Normal Text> sdklfjsdklfj;</Normal Text><br/>
0042 <Normal Text> </Normal Text><ControlFlow>else</ControlFlow><br/>
0043 <Normal Text> sdfdfsdf;</Normal Text><br/>
0044 <Normal Text> </Normal Text><ControlFlow>end if</ControlFlow><Normal Text>;</Normal Text><br/>
0045 <ControlFlow>end</ControlFlow><Normal Text>;</Normal Text><br/>
0046 <Normal Text></Normal Text><br/>
0047 <Keyword>CREATE</Keyword><Normal Text> </Normal Text><Keyword>TABLE</Keyword><Normal Text> Persons (</Normal Text><br/>
0048 <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/>
0049 <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/>
0050 <Normal Text> FirstName </Normal Text><Data Type>varchar</Data Type><Normal Text>(</Normal Text><Number>255</Number><Normal Text>),</Normal Text><br/>
0051 <Normal Text> Age </Normal Text><Data Type>int</Data Type><Normal Text>,</Normal Text><br/>
0052 <Normal Text> City </Normal Text><Data Type>varchar</Data Type><Normal Text>(</Normal Text><Number>255</Number><Normal Text>),</Normal Text><br/>
0053 <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/>
0054 <Normal Text>);</Normal Text><br/>