File indexing completed on 2024-05-12 04:02:10
0001 <!DOCTYPE html> 0002 <html><head> 0003 <meta http-equiv="Content-Type" content="text/html; charset=UTF-8"/> 0004 <title>test.sql_oracle</title> 0005 <meta name="generator" content="KF5::SyntaxHighlighting - Definition (SQL (Oracle)) - Theme (Breeze Light)"/> 0006 </head><body style="background-color:#ffffff;color:#1f1c1b"><pre> 0007 <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> 0008 <span style="color:#898887">-- test case shipped with highlighting in bugzilla, LGPL</span> 0009 0010 <span style="font-weight:bold">declare</span> 0011 v_nchar <span style="color:#0057ae">NCHAR</span>(<span style="color:#b08000">12</span>); 0012 <span style="font-weight:bold">begin</span> 0013 <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> 0014 <span style="color:#ca60ca">nQ'(</span><span style="color:#bf0303">asldflahsl;'dkjfhklsdfh</span><span style="color:#ca60ca">)'</span> 0015 <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 0016 0017 <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; 0018 v_nchar <span style="color:#ca60ca">:=</span> <span style="color:#ca60ca">n'</span><span style="color:#bf0303">NCHAR STRING'</span>; 0019 if_n <span style="color:#ca60ca">:=</span> <span style="color:#b08000">0</span>; 0020 0021 <span style="color:#ca60ca">Q'#</span><span style="color:#bf0303">gdfgsdfgsdfgsdfgsdfg</span><span style="color:#ca60ca">#'</span> afgasasdfasdfasfasdfasdfasdfasdfsdf 0022 0023 <span style="font-weight:bold">if</span> sldfjsdj <span style="font-weight:bold">then</span> 0024 <span style="font-weight:bold">case</span> 0025 <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> 0026 aslfjsldkfj; 0027 <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> 0028 asdfg; 0029 <span style="font-weight:bold">else</span> 0030 <span style="font-weight:bold">null</span>; 0031 <span style="font-weight:bold">end case</span>; 0032 0033 <span style="font-weight:bold">if</span> sdfjh <span style="font-weight:bold">then</span> 0034 <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> 0035 <span style="font-weight:bold">LOOP</span> 0036 dbms_output.put_line(<span style="color:#ca60ca">q';</span><span style="color:#bf0303">ololo</span><span style="color:#ca60ca">;'</span>); 0037 <span style="font-weight:bold">END Loop</span>; 0038 0039 <span style="font-weight:bold">while</span> <span style="font-weight:bold">true</span> 0040 <span style="font-weight:bold">loop</span> 0041 dbms_output.put_line(<span style="color:#bf0303">'1111'</span>); 0042 <span style="font-weight:bold">end loop</span>; 0043 <span style="font-weight:bold">end if</span>; 0044 ksjfklasjd; 0045 fklj; 0046 <span style="font-weight:bold">elsif</span> 0047 sdklfjsdklfj; 0048 <span style="font-weight:bold">else</span> 0049 sdfdfsdf; 0050 <span style="font-weight:bold">end if</span>; 0051 <span style="font-weight:bold">end</span>; 0052 0053 <span style="font-weight:bold">CREATE</span> <span style="font-weight:bold">TABLE</span> Persons ( 0054 <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>, 0055 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>, 0056 FirstName <span style="color:#0057ae">varchar</span>(<span style="color:#b08000">255</span>), 0057 Age <span style="color:#0057ae">int</span>, 0058 City <span style="color:#0057ae">varchar</span>(<span style="color:#b08000">255</span>), 0059 <span style="font-weight:bold">CONSTRAINT</span> CHK_Person <span style="font-weight:bold">CHECK</span> (Age<span style="color:#ca60ca">>=</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>) 0060 ); 0061 </pre></body></html>