autotests/input/test.sql_oracle

0001 -- kate: hl SQL (Oracle)
0002 -- test case shipped with highlighting in bugzilla, LGPL
0003
0004 declare
0005   v_nchar NCHAR(12);
0006 begin
0007         q'{adfasdf'sadfasdf j}'{' hkjhkhkjhkjh khlkhklj'fghdfghdfgh'hkjh'jkhkh'a'
0008         nQ'(asldflahsl;'dkjfhklsdfh)'
0009         Nq'[asdasd;'asdasd'a]sd'asd'asasd]';11111111[1']; asdasdasdasd'errrrrrrrrrrrrrr-p
0010
0011         nq'agdfgsdfgfhfghjfgh'f'f'sdfg'sdfg'dfg#a' dafdfadasfasdf;
0012         v_nchar := n'NCHAR STRING';
0013         if_n := 0;
0014
0015         Q'#gdfgsdfgsdfgsdfgsdfg#' afgasasdfasdfasfasdfasdfasdfasdfsdf
0016
0017         if sldfjsdj then
0018                 case
0019                         when 1=1 then
0020                                 aslfjsldkfj;
0021                         when 2=2 then
0022                                 asdfg;
0023                         else
0024                                 null;
0025                 end case;
0026
0027                 if sdfjh then
0028                         for i in 1 .. 2
0029                         LOOP
0030                                 dbms_output.put_line(q';ololo;');
0031                         END Loop;
0032
0033                         while true
0034                         loop
0035                                 dbms_output.put_line('1111');
0036                         end loop;
0037                 end if;
0038                 ksjfklasjd;
0039                 fklj;
0040         elsif
0041                 sdklfjsdklfj;
0042         else
0043                 sdfdfsdf;
0044         end if;
0045 end;
0046
0047 CREATE TABLE Persons (
0048     ID int NOT NULL,
0049     LastName varchar(255) NOT NULL,
0050     FirstName varchar(255),
0051     Age int,
0052     City varchar(255),
0053     CONSTRAINT CHK_Person CHECK (Age>=18 AND City='Sandnes')
0054 );