-- kate: hl SQL (Oracle)
-- test case shipped with highlighting in bugzilla, LGPL

declare
  v_nchar NCHAR(12);
begin
	q'{adfasdf'sadfasdf j}'{' hkjhkhkjhkjh khlkhklj'fghdfghdfgh'hkjh'jkhkh'a'
	nQ'(asldflahsl;'dkjfhklsdfh)'
	Nq'[asdasd;'asdasd'a]sd'asd'asasd]';11111111[1']; asdasdasdasd'errrrrrrrrrrrrrr-p

	nq'agdfgsdfgfhfghjfgh'f'f'sdfg'sdfg'dfg#a' dafdfadasfasdf;
	v_nchar := n'NCHAR STRING';
	if_n := 0;

	Q'#gdfgsdfgsdfgsdfgsdfg#' afgasasdfasdfasfasdfasdfasdfasdfsdf

	if sldfjsdj then
		case
			when 1=1 then
				aslfjsldkfj;
			when 2=2 then
				asdfg;
			else
				null;
		end case;

		if sdfjh then
			for i in 1 .. 2
			LOOP
				dbms_output.put_line(q';ololo;');
			END Loop;

			while true
			loop
				dbms_output.put_line('1111');
			end loop;
		end if;
		ksjfklasjd;
		fklj;
	elsif
		sdklfjsdklfj;
	else
		sdfdfsdf;
	end if;
end;

CREATE TABLE Persons (
    ID int NOT NULL,
    LastName varchar(255) NOT NULL,
    FirstName varchar(255),
    Age int,
    City varchar(255),
    CONSTRAINT CHK_Person CHECK (Age>=18 AND City='Sandnes')
);