autotests/folding/test.sql_oracle.fold

0001 -- kate: hl SQL (Oracle)
0002 -- test case shipped with highlighting in bugzilla, LGPL
0003
0004 declare
0005   v_nchar NCHAR(12);
0006 <beginfold id='1'>begin</beginfold id='1'>
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         <beginfold id='2'>if</beginfold id='2'> sldfjsdj then
0018                 <beginfold id='3'>case</beginfold id='3'>
0019                         when 1=1 then
0020                                 aslfjsldkfj;
0021                         when 2=2 then
0022                                 asdfg;
0023                         else
0024                                 null;
0025                 <endfold id='3'>end case</endfold id='3'>;
0026
0027                 <beginfold id='2'>if</beginfold id='2'> sdfjh then
0028                         for i in 1 .. 2
0029                         <beginfold id='4'>LOOP</beginfold id='4'>
0030                                 dbms_output.put_line(q';ololo;');
0031                         <endfold id='4'>END Loop</endfold id='4'>;
0032
0033                         while true
0034                         <beginfold id='4'>loop</beginfold id='4'>
0035                                 dbms_output.put_line('1111');
0036                         <endfold id='4'>end loop</endfold id='4'>;
0037                 <endfold id='2'>end if</endfold id='2'>;
0038                 ksjfklasjd;
0039                 fklj;
0040         elsif
0041                 sdklfjsdklfj;
0042         else
0043                 sdfdfsdf;
0044         <endfold id='2'>end if</endfold id='2'>;
0045 <endfold id='1'>end</endfold id='1'>;
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 );