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 Dark)"/> 0006 </head><body style="background-color:#232629;color:#cfcfc2"><pre> 0007 <span style="color:#7a7c7d">-- </span><span style="color:#3f8058">kate:</span><span style="color:#7a7c7d"> </span><span style="color:#7f8c8d">hl</span><span style="color:#f44f4f"> SQL (Oracle)</span> 0008 <span style="color:#7a7c7d">-- test case shipped with highlighting in bugzilla, LGPL</span> 0009 0010 <span style="font-weight:bold">declare</span> 0011 v_nchar <span style="color:#2980b9">NCHAR</span>(<span style="color:#f67400">12</span>); 0012 <span style="color:#fdbc4b;font-weight:bold">begin</span> 0013 <span style="color:#3f8058">q'{</span><span style="color:#f44f4f">adfasdf'sadfasdf j</span><span style="color:#3f8058">}'</span>{<span style="color:#f44f4f">' hkjhkhkjhkjh khlkhklj'</span>fghdfghdfgh<span style="color:#f44f4f">'hkjh'</span>jkhkh<span style="color:#f44f4f">'a'</span> 0014 <span style="color:#3f8058">nQ'(</span><span style="color:#f44f4f">asldflahsl;'dkjfhklsdfh</span><span style="color:#3f8058">)'</span> 0015 <span style="color:#3f8058">Nq'[</span><span style="color:#f44f4f">asdasd;'asdasd'a]sd'asd'asasd</span><span style="color:#3f8058">]'</span>;<span style="color:#f67400">11111111</span>[<span style="color:#f67400">1</span><span style="color:#f44f4f">']; asdasdasdasd'</span>errrrrrrrrrrrrrr<span style="color:#3f8058">-</span>p 0016 0017 <span style="color:#3f8058">nq'a</span><span style="color:#f44f4f">gdfgsdfgfhfghjfgh'f'f'sdfg'sdfg'dfg#</span><span style="color:#3f8058">a'</span> dafdfadasfasdf; 0018 v_nchar <span style="color:#3f8058">:=</span> <span style="color:#3f8058">n'</span><span style="color:#f44f4f">NCHAR STRING'</span>; 0019 if_n <span style="color:#3f8058">:=</span> <span style="color:#f67400">0</span>; 0020 0021 <span style="color:#3f8058">Q'#</span><span style="color:#f44f4f">gdfgsdfgsdfgsdfgsdfg</span><span style="color:#3f8058">#'</span> afgasasdfasdfasfasdfasdfasdfasdfsdf 0022 0023 <span style="color:#fdbc4b;font-weight:bold">if</span> sldfjsdj <span style="color:#fdbc4b;font-weight:bold">then</span> 0024 <span style="color:#fdbc4b;font-weight:bold">case</span> 0025 <span style="color:#fdbc4b;font-weight:bold">when</span> <span style="color:#f67400">1</span><span style="color:#3f8058">=</span><span style="color:#f67400">1</span> <span style="color:#fdbc4b;font-weight:bold">then</span> 0026 aslfjsldkfj; 0027 <span style="color:#fdbc4b;font-weight:bold">when</span> <span style="color:#f67400">2</span><span style="color:#3f8058">=</span><span style="color:#f67400">2</span> <span style="color:#fdbc4b;font-weight:bold">then</span> 0028 asdfg; 0029 <span style="color:#fdbc4b;font-weight:bold">else</span> 0030 <span style="font-weight:bold">null</span>; 0031 <span style="color:#fdbc4b;font-weight:bold">end case</span>; 0032 0033 <span style="color:#fdbc4b;font-weight:bold">if</span> sdfjh <span style="color:#fdbc4b;font-weight:bold">then</span> 0034 <span style="color:#fdbc4b;font-weight:bold">for</span> i <span style="font-weight:bold">in</span> <span style="color:#f67400">1</span> <span style="color:#3f8058">..</span> <span style="color:#f67400">2</span> 0035 <span style="color:#fdbc4b;font-weight:bold">LOOP</span> 0036 dbms_output.put_line(<span style="color:#3f8058">q';</span><span style="color:#f44f4f">ololo</span><span style="color:#3f8058">;'</span>); 0037 <span style="color:#fdbc4b;font-weight:bold">END Loop</span>; 0038 0039 <span style="color:#fdbc4b;font-weight:bold">while</span> <span style="font-weight:bold">true</span> 0040 <span style="color:#fdbc4b;font-weight:bold">loop</span> 0041 dbms_output.put_line(<span style="color:#f44f4f">'1111'</span>); 0042 <span style="color:#fdbc4b;font-weight:bold">end loop</span>; 0043 <span style="color:#fdbc4b;font-weight:bold">end if</span>; 0044 ksjfklasjd; 0045 fklj; 0046 <span style="color:#fdbc4b;font-weight:bold">elsif</span> 0047 sdklfjsdklfj; 0048 <span style="color:#fdbc4b;font-weight:bold">else</span> 0049 sdfdfsdf; 0050 <span style="color:#fdbc4b;font-weight:bold">end if</span>; 0051 <span style="color:#fdbc4b;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:#2980b9">int</span> <span style="font-weight:bold">NOT</span> <span style="font-weight:bold">NULL</span>, 0055 LastName <span style="color:#2980b9">varchar</span>(<span style="color:#f67400">255</span>) <span style="font-weight:bold">NOT</span> <span style="font-weight:bold">NULL</span>, 0056 FirstName <span style="color:#2980b9">varchar</span>(<span style="color:#f67400">255</span>), 0057 Age <span style="color:#2980b9">int</span>, 0058 City <span style="color:#2980b9">varchar</span>(<span style="color:#f67400">255</span>), 0059 <span style="font-weight:bold">CONSTRAINT</span> CHK_Person <span style="font-weight:bold">CHECK</span> (Age<span style="color:#3f8058">>=</span><span style="color:#f67400">18</span> <span style="font-weight:bold">AND</span> City<span style="color:#3f8058">=</span><span style="color:#f44f4f">'Sandnes'</span>) 0060 ); 0061 </pre></body></html>