Changeset View

Standalone View

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
4	declare	4	declare
5	v_nchar NCHAR(12);	5	v_nchar NCHAR(12);
6	begin	6	begin
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	if sldfjsdj then	17	if sldfjsdj then
17	case	18	case
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	end if;	44	end if;
44	end;	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	);