Differential D11470 Diff 40010 autotests/folding/test.sql_oracle.fold

Changeset View

Standalone View

View Options

autotests/folding/test.sql_oracle.fold

1-- kate: hl SQL (Oracle) 1​-- kate: hl SQL (Oracle)
2-- test case shipped with highlighting in bugzilla, LGPL 2​-- test case shipped with highlighting in bugzilla, LGPL
3 3​
4declare 4​declare
5 v_nchar NCHAR(12); 5​ v_nchar NCHAR(12);
6<beginfold id='4'>begin</beginfold id='4'> 6​<beginfold id='4'>begin</beginfold id='4'>
7 q'{adfasdf'sadfasdf j}'{' hkjhkhkjhkjh khlkhklj'fghdfghdfgh'hkjh'jkhkh'a' 7​ q'{adfasdf'sadfasdf j}'{' hkjhkhkjhkjh khlkhklj'fghdfghdfgh'hkjh'jkhkh'a'
8 nQ'(asldflahsl;'dkjfhklsdfh)' 8​ nQ'(asldflahsl;'dkjfhklsdfh)'
9 Nq'[asdasd;'asdasd'a]sd'asd'asasd]';11111111[1']; asdasdasdasd'errrrrrrrrrrrrrr-p 9​ Nq'[asdasd;'asdasd'a]sd'asd'asasd]';11111111[1']; asdasdasdasd'errrrrrrrrrrrrrr-p
10 10​
11 nq'agdfgsdfgfhfghjfgh'f'f'sdfg'sdfg'dfg#a' dafdfadasfasdf; 11​ nq'agdfgsdfgfhfghjfgh'f'f'sdfg'sdfg'dfg#a' dafdfadasfasdf;
12 v_nchar := n'NCHAR STRING'; 12​ v_nchar := n'NCHAR STRING';
13​ if_n := 0;
13 14​
14 Q'#gdfgsdfgsdfgsdfgsdfg#' afgasasdfasdfasfasdfasdfasdfasdfsdf 15​ Q'#gdfgsdfgsdfgsdfgsdfg#' afgasasdfasdfasfasdfasdfasdfasdfsdf
15 16​
16 <beginfold id='1'>if</beginfold id='1'> sldfjsdj then 17​ <beginfold id='1'>if</beginfold id='1'> sldfjsdj then
17 <beginfold id='2'>case</beginfold id='2'> 18​ <beginfold id='2'>case</beginfold id='2'>
18 when 1=1 then 19​ when 1=1 then
19 aslfjsldkfj; 20​ aslfjsldkfj;
20 when 2=2 then 21​ when 2=2 then
Show All 16 Lines
37 ksjfklasjd; 38​ ksjfklasjd;
38 fklj; 39​ fklj;
39 elsif 40​ elsif
40 sdklfjsdklfj; 41​ sdklfjsdklfj;
41 else 42​ else
42 sdfdfsdf; 43​ sdfdfsdf;
43 <endfold id='1'>end if</endfold id='1'>; 44​ <endfold id='1'>end if</endfold id='1'>;
44<endfold id='4'>end</endfold id='4'>; 45​<endfold id='4'>end</endfold id='4'>;
46​
47​CREATE TABLE Persons (
48​ ID int NOT NULL,
49​ LastName varchar(255) NOT NULL,
50​ FirstName varchar(255),
51​ Age int,
52​ City varchar(255),
53​ CONSTRAINT CHK_Person CHECK (Age>=18 AND City='Sandnes')
54​);