Debian Codegraph @

autotests/input/test.sql_oracle

raw
1 -- kate: hl SQL (Oracle)
2 -- test case shipped with highlighting in bugzilla, LGPL
3
4 declare
5 v_nchar NCHAR(12);
6 begin
7 q'{adfasdf'sadfasdf j}'{' hkjhkhkjhkjh khlkhklj'fghdfghdfgh'hkjh'jkhkh'a'
8 nQ'(asldflahsl;'dkjfhklsdfh)'
9 Nq'[asdasd;'asdasd'a]sd'asd'asasd]';11111111[1']; asdasdasdasd'errrrrrrrrrrrrrr-p
10
11 nq'agdfgsdfgfhfghjfgh'f'f'sdfg'sdfg'dfg#a' dafdfadasfasdf;
12 v_nchar := n'NCHAR STRING';
13 if_n := 0;
14
15 Q'#gdfgsdfgsdfgsdfgsdfg#' afgasasdfasdfasfasdfasdfasdfasdfsdf
16
17 if sldfjsdj then
18 case
19 when 1=1 then
20 aslfjsldkfj;
21 when 2=2 then
22 asdfg;
23 else
24 null;
25 end case;
26
27 if sdfjh then
28 for i in 1 .. 2
29 LOOP
30 dbms_output.put_line(q';ololo;');
31 END Loop;
32
33 while true
34 loop
35 dbms_output.put_line('1111');
36 end loop;
37 end if;
38 ksjfklasjd;
39 fklj;
40 elsif
41 sdklfjsdklfj;
42 else
43 sdfdfsdf;
44 end if;
45 end;
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 );