File: test.sql_oracle

package info (click to toggle)
kf6-syntax-highlighting 6.13.0-1
  • links: PTS, VCS
  • area: main
  • in suites: trixie
  • size: 47,568 kB
  • sloc: xml: 197,750; cpp: 12,850; python: 3,023; sh: 955; perl: 546; ruby: 488; pascal: 393; javascript: 161; php: 150; jsp: 132; lisp: 131; haskell: 124; ada: 119; ansic: 107; makefile: 96; f90: 94; ml: 85; cobol: 81; yacc: 71; csh: 62; erlang: 54; sql: 51; java: 47; objc: 37; awk: 31; asm: 30; tcl: 29; fortran: 18; cs: 10
file content (54 lines) | stat: -rw-r--r-- 1,052 bytes parent folder | download | duplicates (6) 
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
 
-- 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')
);