annotate runtime/syntax/plsql.vim @ 23057:35ba3a465deb

Added tag v8.2.2074 for changeset 57b6427c18e4d7e4c713c84528a6ee189c7b9ab0
author Bram Moolenaar <Bram@vim.org>
date Tue, 01 Dec 2020 20:15:04 +0100
parents 46763b01cd9a
children 4d76b3e07c07
Ignore whitespace changes - Everywhere: Within whitespace: At end of lines:
rev   line source
7
3fc0f57ecb91 updated for version 7.0001
vimboss
parents:
diff changeset
1 " Vim syntax file
3fc0f57ecb91 updated for version 7.0001
vimboss
parents:
diff changeset
2 " Language: Oracle Procedureal SQL (PL/SQL)
3fc0f57ecb91 updated for version 7.0001
vimboss
parents:
diff changeset
3 " Maintainer: Jeff Lanzarotta (jefflanzarotta at yahoo dot com)
3fc0f57ecb91 updated for version 7.0001
vimboss
parents:
diff changeset
4 " Original Maintainer: C. Laurence Gonsalves (clgonsal@kami.com)
3fc0f57ecb91 updated for version 7.0001
vimboss
parents:
diff changeset
5 " URL: http://lanzarotta.tripod.com/vim/syntax/plsql.vim.zip
3fc0f57ecb91 updated for version 7.0001
vimboss
parents:
diff changeset
6 " Last Change: September 18, 2002
3fc0f57ecb91 updated for version 7.0001
vimboss
parents:
diff changeset
7 " History: Geoff Evans & Bill Pribyl (bill at plnet dot org)
3fc0f57ecb91 updated for version 7.0001
vimboss
parents:
diff changeset
8 " Added 9i keywords.
3fc0f57ecb91 updated for version 7.0001
vimboss
parents:
diff changeset
9 " Austin Ziegler (austin at halostatue dot ca)
3fc0f57ecb91 updated for version 7.0001
vimboss
parents:
diff changeset
10 " Added 8i+ features.
3fc0f57ecb91 updated for version 7.0001
vimboss
parents:
diff changeset
11 "
10048
43efa4f5a8ea commit https://github.com/vim/vim/commit/89bcfda6834aba724d12554a34b9ed49f5789fd5
Christian Brabandt <cb@256bit.org>
parents: 7
diff changeset
12 " quit when a syntax file was already loaded
43efa4f5a8ea commit https://github.com/vim/vim/commit/89bcfda6834aba724d12554a34b9ed49f5789fd5
Christian Brabandt <cb@256bit.org>
parents: 7
diff changeset
13 if exists("b:current_syntax")
7
3fc0f57ecb91 updated for version 7.0001
vimboss
parents:
diff changeset
14 finish
3fc0f57ecb91 updated for version 7.0001
vimboss
parents:
diff changeset
15 endif
3fc0f57ecb91 updated for version 7.0001
vimboss
parents:
diff changeset
16
3fc0f57ecb91 updated for version 7.0001
vimboss
parents:
diff changeset
17 " Todo.
3fc0f57ecb91 updated for version 7.0001
vimboss
parents:
diff changeset
18 syn keyword plsqlTodo TODO FIXME XXX DEBUG NOTE
3fc0f57ecb91 updated for version 7.0001
vimboss
parents:
diff changeset
19 syn cluster plsqlCommentGroup contains=plsqlTodo
3fc0f57ecb91 updated for version 7.0001
vimboss
parents:
diff changeset
20
3fc0f57ecb91 updated for version 7.0001
vimboss
parents:
diff changeset
21 syn case ignore
3fc0f57ecb91 updated for version 7.0001
vimboss
parents:
diff changeset
22
3fc0f57ecb91 updated for version 7.0001
vimboss
parents:
diff changeset
23 syn match plsqlGarbage "[^ \t()]"
3fc0f57ecb91 updated for version 7.0001
vimboss
parents:
diff changeset
24 syn match plsqlIdentifier "[a-z][a-z0-9$_#]*"
3fc0f57ecb91 updated for version 7.0001
vimboss
parents:
diff changeset
25 syn match plsqlHostIdentifier ":[a-z][a-z0-9$_#]*"
3fc0f57ecb91 updated for version 7.0001
vimboss
parents:
diff changeset
26
3fc0f57ecb91 updated for version 7.0001
vimboss
parents:
diff changeset
27 " When wanted, highlight the trailing whitespace.
3fc0f57ecb91 updated for version 7.0001
vimboss
parents:
diff changeset
28 if exists("c_space_errors")
3fc0f57ecb91 updated for version 7.0001
vimboss
parents:
diff changeset
29 if !exists("c_no_trail_space_error")
3fc0f57ecb91 updated for version 7.0001
vimboss
parents:
diff changeset
30 syn match plsqlSpaceError "\s\+$"
3fc0f57ecb91 updated for version 7.0001
vimboss
parents:
diff changeset
31 endif
3fc0f57ecb91 updated for version 7.0001
vimboss
parents:
diff changeset
32
3fc0f57ecb91 updated for version 7.0001
vimboss
parents:
diff changeset
33 if !exists("c_no_tab_space_error")
3fc0f57ecb91 updated for version 7.0001
vimboss
parents:
diff changeset
34 syn match plsqlSpaceError " \+\t"me=e-1
3fc0f57ecb91 updated for version 7.0001
vimboss
parents:
diff changeset
35 endif
3fc0f57ecb91 updated for version 7.0001
vimboss
parents:
diff changeset
36 endif
3fc0f57ecb91 updated for version 7.0001
vimboss
parents:
diff changeset
37
3fc0f57ecb91 updated for version 7.0001
vimboss
parents:
diff changeset
38 " Symbols.
3fc0f57ecb91 updated for version 7.0001
vimboss
parents:
diff changeset
39 syn match plsqlSymbol "\(;\|,\|\.\)"
3fc0f57ecb91 updated for version 7.0001
vimboss
parents:
diff changeset
40
3fc0f57ecb91 updated for version 7.0001
vimboss
parents:
diff changeset
41 " Operators.
3fc0f57ecb91 updated for version 7.0001
vimboss
parents:
diff changeset
42 syn match plsqlOperator "\(+\|-\|\*\|/\|=\|<\|>\|@\|\*\*\|!=\|\~=\)"
3fc0f57ecb91 updated for version 7.0001
vimboss
parents:
diff changeset
43 syn match plsqlOperator "\(^=\|<=\|>=\|:=\|=>\|\.\.\|||\|<<\|>>\|\"\)"
3fc0f57ecb91 updated for version 7.0001
vimboss
parents:
diff changeset
44
3fc0f57ecb91 updated for version 7.0001
vimboss
parents:
diff changeset
45 " Some of Oracle's SQL keywords.
3fc0f57ecb91 updated for version 7.0001
vimboss
parents:
diff changeset
46 syn keyword plsqlSQLKeyword ABORT ACCESS ACCESSED ADD AFTER ALL ALTER AND ANY
3fc0f57ecb91 updated for version 7.0001
vimboss
parents:
diff changeset
47 syn keyword plsqlSQLKeyword AS ASC ATTRIBUTE AUDIT AUTHORIZATION AVG BASE_TABLE
3fc0f57ecb91 updated for version 7.0001
vimboss
parents:
diff changeset
48 syn keyword plsqlSQLKeyword BEFORE BETWEEN BY CASCADE CAST CHECK CLUSTER
3fc0f57ecb91 updated for version 7.0001
vimboss
parents:
diff changeset
49 syn keyword plsqlSQLKeyword CLUSTERS COLAUTH COLUMN COMMENT COMPRESS CONNECT
3fc0f57ecb91 updated for version 7.0001
vimboss
parents:
diff changeset
50 syn keyword plsqlSQLKeyword CONSTRAINT CRASH CREATE CURRENT DATA DATABASE
3fc0f57ecb91 updated for version 7.0001
vimboss
parents:
diff changeset
51 syn keyword plsqlSQLKeyword DATA_BASE DBA DEFAULT DELAY DELETE DESC DISTINCT
3fc0f57ecb91 updated for version 7.0001
vimboss
parents:
diff changeset
52 syn keyword plsqlSQLKeyword DROP DUAL ELSE EXCLUSIVE EXISTS EXTENDS EXTRACT
3fc0f57ecb91 updated for version 7.0001
vimboss
parents:
diff changeset
53 syn keyword plsqlSQLKeyword FILE FORCE FOREIGN FROM GRANT GROUP HAVING HEAP
3fc0f57ecb91 updated for version 7.0001
vimboss
parents:
diff changeset
54 syn keyword plsqlSQLKeyword IDENTIFIED IDENTIFIER IMMEDIATE IN INCLUDING
3fc0f57ecb91 updated for version 7.0001
vimboss
parents:
diff changeset
55 syn keyword plsqlSQLKeyword INCREMENT INDEX INDEXES INITIAL INSERT INSTEAD
3fc0f57ecb91 updated for version 7.0001
vimboss
parents:
diff changeset
56 syn keyword plsqlSQLKeyword INTERSECT INTO INVALIDATE IS ISOLATION KEY LIBRARY
3fc0f57ecb91 updated for version 7.0001
vimboss
parents:
diff changeset
57 syn keyword plsqlSQLKeyword LIKE LOCK MAXEXTENTS MINUS MODE MODIFY MULTISET
3fc0f57ecb91 updated for version 7.0001
vimboss
parents:
diff changeset
58 syn keyword plsqlSQLKeyword NESTED NOAUDIT NOCOMPRESS NOT NOWAIT OF OFF OFFLINE
3fc0f57ecb91 updated for version 7.0001
vimboss
parents:
diff changeset
59 syn keyword plsqlSQLKeyword ON ONLINE OPERATOR OPTION OR ORDER ORGANIZATION
3fc0f57ecb91 updated for version 7.0001
vimboss
parents:
diff changeset
60 syn keyword plsqlSQLKeyword PCTFREE PRIMARY PRIOR PRIVATE PRIVILEGES PUBLIC
3fc0f57ecb91 updated for version 7.0001
vimboss
parents:
diff changeset
61 syn keyword plsqlSQLKeyword QUOTA RELEASE RENAME REPLACE RESOURCE REVOKE ROLLBACK
3fc0f57ecb91 updated for version 7.0001
vimboss
parents:
diff changeset
62 syn keyword plsqlSQLKeyword ROW ROWLABEL ROWS SCHEMA SELECT SEPARATE SESSION SET
3fc0f57ecb91 updated for version 7.0001
vimboss
parents:
diff changeset
63 syn keyword plsqlSQLKeyword SHARE SIZE SPACE START STORE SUCCESSFUL SYNONYM
3fc0f57ecb91 updated for version 7.0001
vimboss
parents:
diff changeset
64 syn keyword plsqlSQLKeyword SYSDATE TABLE TABLES TABLESPACE TEMPORARY TO TREAT
3fc0f57ecb91 updated for version 7.0001
vimboss
parents:
diff changeset
65 syn keyword plsqlSQLKeyword TRIGGER TRUNCATE UID UNION UNIQUE UNLIMITED UPDATE
3fc0f57ecb91 updated for version 7.0001
vimboss
parents:
diff changeset
66 syn keyword plsqlSQLKeyword USE USER VALIDATE VALUES VIEW WHENEVER WHERE WITH
3fc0f57ecb91 updated for version 7.0001
vimboss
parents:
diff changeset
67
3fc0f57ecb91 updated for version 7.0001
vimboss
parents:
diff changeset
68 " PL/SQL's own keywords.
3fc0f57ecb91 updated for version 7.0001
vimboss
parents:
diff changeset
69 syn keyword plsqlKeyword AGENT AND ANY ARRAY ASSIGN AS AT AUTHID BEGIN BODY BY
3fc0f57ecb91 updated for version 7.0001
vimboss
parents:
diff changeset
70 syn keyword plsqlKeyword BULK C CASE CHAR_BASE CHARSETFORM CHARSETID CLOSE
3fc0f57ecb91 updated for version 7.0001
vimboss
parents:
diff changeset
71 syn keyword plsqlKeyword COLLECT CONSTANT CONSTRUCTOR CONTEXT CURRVAL DECLARE
3fc0f57ecb91 updated for version 7.0001
vimboss
parents:
diff changeset
72 syn keyword plsqlKeyword DVOID EXCEPTION EXCEPTION_INIT EXECUTE EXIT FETCH
3fc0f57ecb91 updated for version 7.0001
vimboss
parents:
diff changeset
73 syn keyword plsqlKeyword FINAL FUNCTION GOTO HASH IMMEDIATE IN INDICATOR
3fc0f57ecb91 updated for version 7.0001
vimboss
parents:
diff changeset
74 syn keyword plsqlKeyword INSTANTIABLE IS JAVA LANGUAGE LIBRARY MAP MAXLEN
3fc0f57ecb91 updated for version 7.0001
vimboss
parents:
diff changeset
75 syn keyword plsqlKeyword MEMBER NAME NEW NOCOPY NUMBER_BASE OBJECT OCICOLL
3fc0f57ecb91 updated for version 7.0001
vimboss
parents:
diff changeset
76 syn keyword plsqlKeyword OCIDATE OCIDATETIME OCILOBLOCATOR OCINUMBER OCIRAW
3fc0f57ecb91 updated for version 7.0001
vimboss
parents:
diff changeset
77 syn keyword plsqlKeyword OCISTRING OF OPAQUE OPEN OR ORDER OTHERS OUT
3fc0f57ecb91 updated for version 7.0001
vimboss
parents:
diff changeset
78 syn keyword plsqlKeyword OVERRIDING PACKAGE PARALLEL_ENABLE PARAMETERS
3fc0f57ecb91 updated for version 7.0001
vimboss
parents:
diff changeset
79 syn keyword plsqlKeyword PARTITION PIPELINED PRAGMA PROCEDURE RAISE RANGE REF
3fc0f57ecb91 updated for version 7.0001
vimboss
parents:
diff changeset
80 syn keyword plsqlKeyword RESULT RETURN REVERSE ROWTYPE SB1 SELF SHORT SIZE_T
3fc0f57ecb91 updated for version 7.0001
vimboss
parents:
diff changeset
81 syn keyword plsqlKeyword SQL SQLCODE SQLERRM STATIC STRUCT SUBTYPE TDO THEN
3fc0f57ecb91 updated for version 7.0001
vimboss
parents:
diff changeset
82 syn keyword plsqlKeyword TABLE TIMEZONE_ABBR TIMEZONE_HOUR TIMEZONE_MINUTE
3fc0f57ecb91 updated for version 7.0001
vimboss
parents:
diff changeset
83 syn keyword plsqlKeyword TIMEZONE_REGION TYPE UNDER UNSIGNED USING VARIANCE
3fc0f57ecb91 updated for version 7.0001
vimboss
parents:
diff changeset
84 syn keyword plsqlKeyword VARRAY VARYING WHEN WRITE
3fc0f57ecb91 updated for version 7.0001
vimboss
parents:
diff changeset
85 syn match plsqlKeyword "\<END\>"
3fc0f57ecb91 updated for version 7.0001
vimboss
parents:
diff changeset
86 syn match plsqlKeyword "\.COUNT\>"hs=s+1
3fc0f57ecb91 updated for version 7.0001
vimboss
parents:
diff changeset
87 syn match plsqlKeyword "\.EXISTS\>"hs=s+1
3fc0f57ecb91 updated for version 7.0001
vimboss
parents:
diff changeset
88 syn match plsqlKeyword "\.FIRST\>"hs=s+1
3fc0f57ecb91 updated for version 7.0001
vimboss
parents:
diff changeset
89 syn match plsqlKeyword "\.LAST\>"hs=s+1
3fc0f57ecb91 updated for version 7.0001
vimboss
parents:
diff changeset
90 syn match plsqlKeyword "\.DELETE\>"hs=s+1
3fc0f57ecb91 updated for version 7.0001
vimboss
parents:
diff changeset
91 syn match plsqlKeyword "\.PREV\>"hs=s+1
3fc0f57ecb91 updated for version 7.0001
vimboss
parents:
diff changeset
92 syn match plsqlKeyword "\.NEXT\>"hs=s+1
3fc0f57ecb91 updated for version 7.0001
vimboss
parents:
diff changeset
93
3fc0f57ecb91 updated for version 7.0001
vimboss
parents:
diff changeset
94 " PL/SQL functions.
3fc0f57ecb91 updated for version 7.0001
vimboss
parents:
diff changeset
95 syn keyword plsqlFunction ABS ACOS ADD_MONTHS ASCII ASCIISTR ASIN ATAN ATAN2
3fc0f57ecb91 updated for version 7.0001
vimboss
parents:
diff changeset
96 syn keyword plsqlFunction BFILENAME BITAND CEIL CHARTOROWID CHR COALESCE
3fc0f57ecb91 updated for version 7.0001
vimboss
parents:
diff changeset
97 syn keyword plsqlFunction COMMIT COMMIT_CM COMPOSE CONCAT CONVERT COS COSH
3fc0f57ecb91 updated for version 7.0001
vimboss
parents:
diff changeset
98 syn keyword plsqlFunction COUNT CUBE CURRENT_DATE CURRENT_TIME CURRENT_TIMESTAMP
3fc0f57ecb91 updated for version 7.0001
vimboss
parents:
diff changeset
99 syn keyword plsqlFunction DBTIMEZONE DECODE DECOMPOSE DEREF DUMP EMPTY_BLOB
3fc0f57ecb91 updated for version 7.0001
vimboss
parents:
diff changeset
100 syn keyword plsqlFunction EMPTY_CLOB EXISTS EXP FLOOR FROM_TZ GETBND GLB
3fc0f57ecb91 updated for version 7.0001
vimboss
parents:
diff changeset
101 syn keyword plsqlFunction GREATEST GREATEST_LB GROUPING HEXTORAW INITCAP
3fc0f57ecb91 updated for version 7.0001
vimboss
parents:
diff changeset
102 syn keyword plsqlFunction INSTR INSTR2 INSTR4 INSTRB INSTRC ISNCHAR LAST_DAY
3fc0f57ecb91 updated for version 7.0001
vimboss
parents:
diff changeset
103 syn keyword plsqlFunction LEAST LEAST_UB LENGTH LENGTH2 LENGTH4 LENGTHB LENGTHC
3fc0f57ecb91 updated for version 7.0001
vimboss
parents:
diff changeset
104 syn keyword plsqlFunction LN LOCALTIME LOCALTIMESTAMP LOG LOWER LPAD
3fc0f57ecb91 updated for version 7.0001
vimboss
parents:
diff changeset
105 syn keyword plsqlFunction LTRIM LUB MAKE_REF MAX MIN MOD MONTHS_BETWEEN
3fc0f57ecb91 updated for version 7.0001
vimboss
parents:
diff changeset
106 syn keyword plsqlFunction NCHARTOROWID NCHR NEW_TIME NEXT_DAY NHEXTORAW
3fc0f57ecb91 updated for version 7.0001
vimboss
parents:
diff changeset
107 syn keyword plsqlFunction NLS_CHARSET_DECL_LEN NLS_CHARSET_ID NLS_CHARSET_NAME
3fc0f57ecb91 updated for version 7.0001
vimboss
parents:
diff changeset
108 syn keyword plsqlFunction NLS_INITCAP NLS_LOWER NLSSORT NLS_UPPER NULLFN NULLIF
3fc0f57ecb91 updated for version 7.0001
vimboss
parents:
diff changeset
109 syn keyword plsqlFunction NUMTODSINTERVAL NUMTOYMINTERVAL NVL POWER
3fc0f57ecb91 updated for version 7.0001
vimboss
parents:
diff changeset
110 syn keyword plsqlFunction RAISE_APPLICATION_ERROR RAWTOHEX RAWTONHEX REF
3fc0f57ecb91 updated for version 7.0001
vimboss
parents:
diff changeset
111 syn keyword plsqlFunction REFTOHEX REPLACE ROLLBACK_NR ROLLBACK_SV ROLLUP ROUND
3fc0f57ecb91 updated for version 7.0001
vimboss
parents:
diff changeset
112 syn keyword plsqlFunction ROWIDTOCHAR ROWIDTONCHAR ROWLABEL RPAD RTRIM
3fc0f57ecb91 updated for version 7.0001
vimboss
parents:
diff changeset
113 syn keyword plsqlFunction SAVEPOINT SESSIONTIMEZONE SETBND SET_TRANSACTION_USE
3fc0f57ecb91 updated for version 7.0001
vimboss
parents:
diff changeset
114 syn keyword plsqlFunction SIGN SIN SINH SOUNDEX SQLCODE SQLERRM SQRT STDDEV
3fc0f57ecb91 updated for version 7.0001
vimboss
parents:
diff changeset
115 syn keyword plsqlFunction SUBSTR SUBSTR2 SUBSTR4 SUBSTRB SUBSTRC SUM
3fc0f57ecb91 updated for version 7.0001
vimboss
parents:
diff changeset
116 syn keyword plsqlFunction SYS_AT_TIME_ZONE SYS_CONTEXT SYSDATE SYS_EXTRACT_UTC
3fc0f57ecb91 updated for version 7.0001
vimboss
parents:
diff changeset
117 syn keyword plsqlFunction SYS_GUID SYS_LITERALTODATE SYS_LITERALTODSINTERVAL
3fc0f57ecb91 updated for version 7.0001
vimboss
parents:
diff changeset
118 syn keyword plsqlFunction SYS_LITERALTOTIME SYS_LITERALTOTIMESTAMP
3fc0f57ecb91 updated for version 7.0001
vimboss
parents:
diff changeset
119 syn keyword plsqlFunction SYS_LITERALTOTZTIME SYS_LITERALTOTZTIMESTAMP
3fc0f57ecb91 updated for version 7.0001
vimboss
parents:
diff changeset
120 syn keyword plsqlFunction SYS_LITERALTOYMINTERVAL SYS_OVER__DD SYS_OVER__DI
3fc0f57ecb91 updated for version 7.0001
vimboss
parents:
diff changeset
121 syn keyword plsqlFunction SYS_OVER__ID SYS_OVER_IID SYS_OVER_IIT
3fc0f57ecb91 updated for version 7.0001
vimboss
parents:
diff changeset
122 syn keyword plsqlFunction SYS_OVER__IT SYS_OVER__TI SYS_OVER__TT
3fc0f57ecb91 updated for version 7.0001
vimboss
parents:
diff changeset
123 syn keyword plsqlFunction SYSTIMESTAMP TAN TANH TO_ANYLOB TO_BLOB TO_CHAR
3fc0f57ecb91 updated for version 7.0001
vimboss
parents:
diff changeset
124 syn keyword plsqlFunction TO_CLOB TO_DATE TO_DSINTERVAL TO_LABEL TO_MULTI_BYTE
3fc0f57ecb91 updated for version 7.0001
vimboss
parents:
diff changeset
125 syn keyword plsqlFunction TO_NCHAR TO_NCLOB TO_NUMBER TO_RAW TO_SINGLE_BYTE
3fc0f57ecb91 updated for version 7.0001
vimboss
parents:
diff changeset
126 syn keyword plsqlFunction TO_TIME TO_TIMESTAMP TO_TIMESTAMP_TZ TO_TIME_TZ
3fc0f57ecb91 updated for version 7.0001
vimboss
parents:
diff changeset
127 syn keyword plsqlFunction TO_YMINTERVAL TRANSLATE TREAT TRIM TRUNC TZ_OFFSET UID
3fc0f57ecb91 updated for version 7.0001
vimboss
parents:
diff changeset
128 syn keyword plsqlFunction UNISTR UPPER UROWID USER USERENV VALUE VARIANCE
3fc0f57ecb91 updated for version 7.0001
vimboss
parents:
diff changeset
129 syn keyword plsqlFunction VSIZE WORK XOR
3fc0f57ecb91 updated for version 7.0001
vimboss
parents:
diff changeset
130 syn match plsqlFunction "\<SYS\$LOB_REPLICATION\>"
3fc0f57ecb91 updated for version 7.0001
vimboss
parents:
diff changeset
131
3fc0f57ecb91 updated for version 7.0001
vimboss
parents:
diff changeset
132 " PL/SQL Exceptions
3fc0f57ecb91 updated for version 7.0001
vimboss
parents:
diff changeset
133 syn keyword plsqlException ACCESS_INTO_NULL CASE_NOT_FOUND COLLECTION_IS_NULL
3fc0f57ecb91 updated for version 7.0001
vimboss
parents:
diff changeset
134 syn keyword plsqlException CURSOR_ALREADY_OPEN DUP_VAL_ON_INDEX INVALID_CURSOR
3fc0f57ecb91 updated for version 7.0001
vimboss
parents:
diff changeset
135 syn keyword plsqlException INVALID_NUMBER LOGIN_DENIED NO_DATA_FOUND
3fc0f57ecb91 updated for version 7.0001
vimboss
parents:
diff changeset
136 syn keyword plsqlException NOT_LOGGED_ON PROGRAM_ERROR ROWTYPE_MISMATCH
3fc0f57ecb91 updated for version 7.0001
vimboss
parents:
diff changeset
137 syn keyword plsqlException SELF_IS_NULL STORAGE_ERROR SUBSCRIPT_BEYOND_COUNT
3fc0f57ecb91 updated for version 7.0001
vimboss
parents:
diff changeset
138 syn keyword plsqlException SUBSCRIPT_OUTSIDE_LIMIT SYS_INVALID_ROWID
3fc0f57ecb91 updated for version 7.0001
vimboss
parents:
diff changeset
139 syn keyword plsqlException TIMEOUT_ON_RESOURCE TOO_MANY_ROWS VALUE_ERROR
3fc0f57ecb91 updated for version 7.0001
vimboss
parents:
diff changeset
140 syn keyword plsqlException ZERO_DIVIDE
3fc0f57ecb91 updated for version 7.0001
vimboss
parents:
diff changeset
141
3fc0f57ecb91 updated for version 7.0001
vimboss
parents:
diff changeset
142 " Oracle Pseudo Colums.
3fc0f57ecb91 updated for version 7.0001
vimboss
parents:
diff changeset
143 syn keyword plsqlPseudo CURRVAL LEVEL NEXTVAL ROWID ROWNUM
3fc0f57ecb91 updated for version 7.0001
vimboss
parents:
diff changeset
144
3fc0f57ecb91 updated for version 7.0001
vimboss
parents:
diff changeset
145 if exists("plsql_highlight_triggers")
3fc0f57ecb91 updated for version 7.0001
vimboss
parents:
diff changeset
146 syn keyword plsqlTrigger INSERTING UPDATING DELETING
3fc0f57ecb91 updated for version 7.0001
vimboss
parents:
diff changeset
147 endif
3fc0f57ecb91 updated for version 7.0001
vimboss
parents:
diff changeset
148
3fc0f57ecb91 updated for version 7.0001
vimboss
parents:
diff changeset
149 " Conditionals.
3fc0f57ecb91 updated for version 7.0001
vimboss
parents:
diff changeset
150 syn keyword plsqlConditional ELSIF ELSE IF
3fc0f57ecb91 updated for version 7.0001
vimboss
parents:
diff changeset
151 syn match plsqlConditional "\<END\s\+IF\>"
3fc0f57ecb91 updated for version 7.0001
vimboss
parents:
diff changeset
152
3fc0f57ecb91 updated for version 7.0001
vimboss
parents:
diff changeset
153 " Loops.
3fc0f57ecb91 updated for version 7.0001
vimboss
parents:
diff changeset
154 syn keyword plsqlRepeat FOR LOOP WHILE FORALL
3fc0f57ecb91 updated for version 7.0001
vimboss
parents:
diff changeset
155 syn match plsqlRepeat "\<END\s\+LOOP\>"
3fc0f57ecb91 updated for version 7.0001
vimboss
parents:
diff changeset
156
3fc0f57ecb91 updated for version 7.0001
vimboss
parents:
diff changeset
157 " Various types of comments.
3fc0f57ecb91 updated for version 7.0001
vimboss
parents:
diff changeset
158 if exists("c_comment_strings")
3fc0f57ecb91 updated for version 7.0001
vimboss
parents:
diff changeset
159 syntax match plsqlCommentSkip contained "^\s*\*\($\|\s\+\)"
3fc0f57ecb91 updated for version 7.0001
vimboss
parents:
diff changeset
160 syntax region plsqlCommentString contained start=+L\="+ skip=+\\\\\|\\"+ end=+"+ end=+\*/+me=s-1 contains=plsqlCommentSkip
3fc0f57ecb91 updated for version 7.0001
vimboss
parents:
diff changeset
161 syntax region plsqlComment2String contained start=+L\="+ skip=+\\\\\|\\"+ end=+"+ end="$"
3fc0f57ecb91 updated for version 7.0001
vimboss
parents:
diff changeset
162 syntax region plsqlCommentL start="--" skip="\\$" end="$" keepend contains=@plsqlCommentGroup,plsqlComment2String,plsqlCharLiteral,plsqlBooleanLiteral,plsqlNumbersCom,plsqlSpaceError
3fc0f57ecb91 updated for version 7.0001
vimboss
parents:
diff changeset
163 syntax region plsqlComment start="/\*" end="\*/" contains=@plsqlCommentGroup,plsqlComment2String,plsqlCharLiteral,plsqlBooleanLiteral,plsqlNumbersCom,plsqlSpaceError
3fc0f57ecb91 updated for version 7.0001
vimboss
parents:
diff changeset
164 else
3fc0f57ecb91 updated for version 7.0001
vimboss
parents:
diff changeset
165 syntax region plsqlCommentL start="--" skip="\\$" end="$" keepend contains=@plsqlCommentGroup,plsqlSpaceError
3fc0f57ecb91 updated for version 7.0001
vimboss
parents:
diff changeset
166 syntax region plsqlComment start="/\*" end="\*/" contains=@plsqlCommentGroup,plsqlSpaceError
3fc0f57ecb91 updated for version 7.0001
vimboss
parents:
diff changeset
167 endif
3fc0f57ecb91 updated for version 7.0001
vimboss
parents:
diff changeset
168
3fc0f57ecb91 updated for version 7.0001
vimboss
parents:
diff changeset
169 syn sync ccomment plsqlComment
3fc0f57ecb91 updated for version 7.0001
vimboss
parents:
diff changeset
170 syn sync ccomment plsqlCommentL
3fc0f57ecb91 updated for version 7.0001
vimboss
parents:
diff changeset
171
3fc0f57ecb91 updated for version 7.0001
vimboss
parents:
diff changeset
172 " To catch unterminated string literals.
3fc0f57ecb91 updated for version 7.0001
vimboss
parents:
diff changeset
173 syn match plsqlStringError "'.*$"
3fc0f57ecb91 updated for version 7.0001
vimboss
parents:
diff changeset
174
3fc0f57ecb91 updated for version 7.0001
vimboss
parents:
diff changeset
175 " Various types of literals.
3fc0f57ecb91 updated for version 7.0001
vimboss
parents:
diff changeset
176 syn match plsqlNumbers transparent "\<[+-]\=\d\|[+-]\=\.\d" contains=plsqlIntLiteral,plsqlFloatLiteral
3fc0f57ecb91 updated for version 7.0001
vimboss
parents:
diff changeset
177 syn match plsqlNumbersCom contained transparent "\<[+-]\=\d\|[+-]\=\.\d" contains=plsqlIntLiteral,plsqlFloatLiteral
3fc0f57ecb91 updated for version 7.0001
vimboss
parents:
diff changeset
178 syn match plsqlIntLiteral contained "[+-]\=\d\+"
3fc0f57ecb91 updated for version 7.0001
vimboss
parents:
diff changeset
179 syn match plsqlFloatLiteral contained "[+-]\=\d\+\.\d*"
3fc0f57ecb91 updated for version 7.0001
vimboss
parents:
diff changeset
180 syn match plsqlFloatLiteral contained "[+-]\=\d*\.\d*"
3fc0f57ecb91 updated for version 7.0001
vimboss
parents:
diff changeset
181 syn match plsqlCharLiteral "'[^']'"
3fc0f57ecb91 updated for version 7.0001
vimboss
parents:
diff changeset
182 syn match plsqlStringLiteral "'\([^']\|''\)*'"
3fc0f57ecb91 updated for version 7.0001
vimboss
parents:
diff changeset
183 syn keyword plsqlBooleanLiteral TRUE FALSE NULL
3fc0f57ecb91 updated for version 7.0001
vimboss
parents:
diff changeset
184
3fc0f57ecb91 updated for version 7.0001
vimboss
parents:
diff changeset
185 " The built-in types.
3fc0f57ecb91 updated for version 7.0001
vimboss
parents:
diff changeset
186 syn keyword plsqlStorage ANYDATA ANYTYPE BFILE BINARY_INTEGER BLOB BOOLEAN
3fc0f57ecb91 updated for version 7.0001
vimboss
parents:
diff changeset
187 syn keyword plsqlStorage BYTE CHAR CHARACTER CLOB CURSOR DATE DAY DEC DECIMAL
3fc0f57ecb91 updated for version 7.0001
vimboss
parents:
diff changeset
188 syn keyword plsqlStorage DOUBLE DSINTERVAL_UNCONSTRAINED FLOAT HOUR
3fc0f57ecb91 updated for version 7.0001
vimboss
parents:
diff changeset
189 syn keyword plsqlStorage INT INTEGER INTERVAL LOB LONG MINUTE
3fc0f57ecb91 updated for version 7.0001
vimboss
parents:
diff changeset
190 syn keyword plsqlStorage MLSLABEL MONTH NATURAL NATURALN NCHAR NCHAR_CS NCLOB
3fc0f57ecb91 updated for version 7.0001
vimboss
parents:
diff changeset
191 syn keyword plsqlStorage NUMBER NUMERIC NVARCHAR PLS_INT PLS_INTEGER
3fc0f57ecb91 updated for version 7.0001
vimboss
parents:
diff changeset
192 syn keyword plsqlStorage POSITIVE POSITIVEN PRECISION RAW REAL RECORD
3fc0f57ecb91 updated for version 7.0001
vimboss
parents:
diff changeset
193 syn keyword plsqlStorage SECOND SIGNTYPE SMALLINT STRING SYS_REFCURSOR TABLE TIME
3fc0f57ecb91 updated for version 7.0001
vimboss
parents:
diff changeset
194 syn keyword plsqlStorage TIMESTAMP TIMESTAMP_UNCONSTRAINED
3fc0f57ecb91 updated for version 7.0001
vimboss
parents:
diff changeset
195 syn keyword plsqlStorage TIMESTAMP_TZ_UNCONSTRAINED
3fc0f57ecb91 updated for version 7.0001
vimboss
parents:
diff changeset
196 syn keyword plsqlStorage TIMESTAMP_LTZ_UNCONSTRAINED UROWID VARCHAR
3fc0f57ecb91 updated for version 7.0001
vimboss
parents:
diff changeset
197 syn keyword plsqlStorage VARCHAR2 YEAR YMINTERVAL_UNCONSTRAINED ZONE
3fc0f57ecb91 updated for version 7.0001
vimboss
parents:
diff changeset
198
3fc0f57ecb91 updated for version 7.0001
vimboss
parents:
diff changeset
199 " A type-attribute is really a type.
3fc0f57ecb91 updated for version 7.0001
vimboss
parents:
diff changeset
200 syn match plsqlTypeAttribute "%\(TYPE\|ROWTYPE\)\>"
3fc0f57ecb91 updated for version 7.0001
vimboss
parents:
diff changeset
201
3fc0f57ecb91 updated for version 7.0001
vimboss
parents:
diff changeset
202 " All other attributes.
3fc0f57ecb91 updated for version 7.0001
vimboss
parents:
diff changeset
203 syn match plsqlAttribute "%\(BULK_EXCEPTIONS\|BULK_ROWCOUNT\|ISOPEN\|FOUND\|NOTFOUND\|ROWCOUNT\)\>"
3fc0f57ecb91 updated for version 7.0001
vimboss
parents:
diff changeset
204
3fc0f57ecb91 updated for version 7.0001
vimboss
parents:
diff changeset
205 " This'll catch mis-matched close-parens.
3fc0f57ecb91 updated for version 7.0001
vimboss
parents:
diff changeset
206 syn cluster plsqlParenGroup contains=plsqlParenError,@plsqlCommentGroup,plsqlCommentSkip,plsqlIntLiteral,plsqlFloatLiteral,plsqlNumbersCom
3fc0f57ecb91 updated for version 7.0001
vimboss
parents:
diff changeset
207 if exists("c_no_bracket_error")
3fc0f57ecb91 updated for version 7.0001
vimboss
parents:
diff changeset
208 syn region plsqlParen transparent start='(' end=')' contains=ALLBUT,@plsqlParenGroup
3fc0f57ecb91 updated for version 7.0001
vimboss
parents:
diff changeset
209 syn match plsqlParenError ")"
3fc0f57ecb91 updated for version 7.0001
vimboss
parents:
diff changeset
210 syn match plsqlErrInParen contained "[{}]"
3fc0f57ecb91 updated for version 7.0001
vimboss
parents:
diff changeset
211 else
3fc0f57ecb91 updated for version 7.0001
vimboss
parents:
diff changeset
212 syn region plsqlParen transparent start='(' end=')' contains=ALLBUT,@plsqlParenGroup,plsqlErrInBracket
3fc0f57ecb91 updated for version 7.0001
vimboss
parents:
diff changeset
213 syn match plsqlParenError "[\])]"
3fc0f57ecb91 updated for version 7.0001
vimboss
parents:
diff changeset
214 syn match plsqlErrInParen contained "[{}]"
3fc0f57ecb91 updated for version 7.0001
vimboss
parents:
diff changeset
215 syn region plsqlBracket transparent start='\[' end=']' contains=ALLBUT,@plsqlParenGroup,plsqlErrInParen
3fc0f57ecb91 updated for version 7.0001
vimboss
parents:
diff changeset
216 syn match plsqlErrInBracket contained "[);{}]"
3fc0f57ecb91 updated for version 7.0001
vimboss
parents:
diff changeset
217 endif
3fc0f57ecb91 updated for version 7.0001
vimboss
parents:
diff changeset
218
3fc0f57ecb91 updated for version 7.0001
vimboss
parents:
diff changeset
219 " Syntax Synchronizing
3fc0f57ecb91 updated for version 7.0001
vimboss
parents:
diff changeset
220 syn sync minlines=10 maxlines=100
3fc0f57ecb91 updated for version 7.0001
vimboss
parents:
diff changeset
221
3fc0f57ecb91 updated for version 7.0001
vimboss
parents:
diff changeset
222 " Define the default highlighting.
10048
43efa4f5a8ea commit https://github.com/vim/vim/commit/89bcfda6834aba724d12554a34b9ed49f5789fd5
Christian Brabandt <cb@256bit.org>
parents: 7
diff changeset
223 " Only when an item doesn't have highlighting yet.
7
3fc0f57ecb91 updated for version 7.0001
vimboss
parents:
diff changeset
224
10051
46763b01cd9a commit https://github.com/vim/vim/commit/f37506f60f87d52a9e8850e30067645e2b13783c
Christian Brabandt <cb@256bit.org>
parents: 10048
diff changeset
225 hi def link plsqlAttribute Macro
46763b01cd9a commit https://github.com/vim/vim/commit/f37506f60f87d52a9e8850e30067645e2b13783c
Christian Brabandt <cb@256bit.org>
parents: 10048
diff changeset
226 hi def link plsqlBlockError Error
46763b01cd9a commit https://github.com/vim/vim/commit/f37506f60f87d52a9e8850e30067645e2b13783c
Christian Brabandt <cb@256bit.org>
parents: 10048
diff changeset
227 hi def link plsqlBooleanLiteral Boolean
46763b01cd9a commit https://github.com/vim/vim/commit/f37506f60f87d52a9e8850e30067645e2b13783c
Christian Brabandt <cb@256bit.org>
parents: 10048
diff changeset
228 hi def link plsqlCharLiteral Character
46763b01cd9a commit https://github.com/vim/vim/commit/f37506f60f87d52a9e8850e30067645e2b13783c
Christian Brabandt <cb@256bit.org>
parents: 10048
diff changeset
229 hi def link plsqlComment Comment
46763b01cd9a commit https://github.com/vim/vim/commit/f37506f60f87d52a9e8850e30067645e2b13783c
Christian Brabandt <cb@256bit.org>
parents: 10048
diff changeset
230 hi def link plsqlCommentL Comment
46763b01cd9a commit https://github.com/vim/vim/commit/f37506f60f87d52a9e8850e30067645e2b13783c
Christian Brabandt <cb@256bit.org>
parents: 10048
diff changeset
231 hi def link plsqlConditional Conditional
46763b01cd9a commit https://github.com/vim/vim/commit/f37506f60f87d52a9e8850e30067645e2b13783c
Christian Brabandt <cb@256bit.org>
parents: 10048
diff changeset
232 hi def link plsqlError Error
46763b01cd9a commit https://github.com/vim/vim/commit/f37506f60f87d52a9e8850e30067645e2b13783c
Christian Brabandt <cb@256bit.org>
parents: 10048
diff changeset
233 hi def link plsqlErrInBracket Error
46763b01cd9a commit https://github.com/vim/vim/commit/f37506f60f87d52a9e8850e30067645e2b13783c
Christian Brabandt <cb@256bit.org>
parents: 10048
diff changeset
234 hi def link plsqlErrInBlock Error
46763b01cd9a commit https://github.com/vim/vim/commit/f37506f60f87d52a9e8850e30067645e2b13783c
Christian Brabandt <cb@256bit.org>
parents: 10048
diff changeset
235 hi def link plsqlErrInParen Error
46763b01cd9a commit https://github.com/vim/vim/commit/f37506f60f87d52a9e8850e30067645e2b13783c
Christian Brabandt <cb@256bit.org>
parents: 10048
diff changeset
236 hi def link plsqlException Function
46763b01cd9a commit https://github.com/vim/vim/commit/f37506f60f87d52a9e8850e30067645e2b13783c
Christian Brabandt <cb@256bit.org>
parents: 10048
diff changeset
237 hi def link plsqlFloatLiteral Float
46763b01cd9a commit https://github.com/vim/vim/commit/f37506f60f87d52a9e8850e30067645e2b13783c
Christian Brabandt <cb@256bit.org>
parents: 10048
diff changeset
238 hi def link plsqlFunction Function
46763b01cd9a commit https://github.com/vim/vim/commit/f37506f60f87d52a9e8850e30067645e2b13783c
Christian Brabandt <cb@256bit.org>
parents: 10048
diff changeset
239 hi def link plsqlGarbage Error
46763b01cd9a commit https://github.com/vim/vim/commit/f37506f60f87d52a9e8850e30067645e2b13783c
Christian Brabandt <cb@256bit.org>
parents: 10048
diff changeset
240 hi def link plsqlHostIdentifier Label
46763b01cd9a commit https://github.com/vim/vim/commit/f37506f60f87d52a9e8850e30067645e2b13783c
Christian Brabandt <cb@256bit.org>
parents: 10048
diff changeset
241 hi def link plsqlIdentifier Normal
46763b01cd9a commit https://github.com/vim/vim/commit/f37506f60f87d52a9e8850e30067645e2b13783c
Christian Brabandt <cb@256bit.org>
parents: 10048
diff changeset
242 hi def link plsqlIntLiteral Number
46763b01cd9a commit https://github.com/vim/vim/commit/f37506f60f87d52a9e8850e30067645e2b13783c
Christian Brabandt <cb@256bit.org>
parents: 10048
diff changeset
243 hi def link plsqlOperator Operator
46763b01cd9a commit https://github.com/vim/vim/commit/f37506f60f87d52a9e8850e30067645e2b13783c
Christian Brabandt <cb@256bit.org>
parents: 10048
diff changeset
244 hi def link plsqlParen Normal
46763b01cd9a commit https://github.com/vim/vim/commit/f37506f60f87d52a9e8850e30067645e2b13783c
Christian Brabandt <cb@256bit.org>
parents: 10048
diff changeset
245 hi def link plsqlParenError Error
46763b01cd9a commit https://github.com/vim/vim/commit/f37506f60f87d52a9e8850e30067645e2b13783c
Christian Brabandt <cb@256bit.org>
parents: 10048
diff changeset
246 hi def link plsqlSpaceError Error
46763b01cd9a commit https://github.com/vim/vim/commit/f37506f60f87d52a9e8850e30067645e2b13783c
Christian Brabandt <cb@256bit.org>
parents: 10048
diff changeset
247 hi def link plsqlPseudo PreProc
46763b01cd9a commit https://github.com/vim/vim/commit/f37506f60f87d52a9e8850e30067645e2b13783c
Christian Brabandt <cb@256bit.org>
parents: 10048
diff changeset
248 hi def link plsqlKeyword Keyword
46763b01cd9a commit https://github.com/vim/vim/commit/f37506f60f87d52a9e8850e30067645e2b13783c
Christian Brabandt <cb@256bit.org>
parents: 10048
diff changeset
249 hi def link plsqlRepeat Repeat
46763b01cd9a commit https://github.com/vim/vim/commit/f37506f60f87d52a9e8850e30067645e2b13783c
Christian Brabandt <cb@256bit.org>
parents: 10048
diff changeset
250 hi def link plsqlStorage StorageClass
46763b01cd9a commit https://github.com/vim/vim/commit/f37506f60f87d52a9e8850e30067645e2b13783c
Christian Brabandt <cb@256bit.org>
parents: 10048
diff changeset
251 hi def link plsqlSQLKeyword Function
46763b01cd9a commit https://github.com/vim/vim/commit/f37506f60f87d52a9e8850e30067645e2b13783c
Christian Brabandt <cb@256bit.org>
parents: 10048
diff changeset
252 hi def link plsqlStringError Error
46763b01cd9a commit https://github.com/vim/vim/commit/f37506f60f87d52a9e8850e30067645e2b13783c
Christian Brabandt <cb@256bit.org>
parents: 10048
diff changeset
253 hi def link plsqlStringLiteral String
46763b01cd9a commit https://github.com/vim/vim/commit/f37506f60f87d52a9e8850e30067645e2b13783c
Christian Brabandt <cb@256bit.org>
parents: 10048
diff changeset
254 hi def link plsqlCommentString String
46763b01cd9a commit https://github.com/vim/vim/commit/f37506f60f87d52a9e8850e30067645e2b13783c
Christian Brabandt <cb@256bit.org>
parents: 10048
diff changeset
255 hi def link plsqlComment2String String
46763b01cd9a commit https://github.com/vim/vim/commit/f37506f60f87d52a9e8850e30067645e2b13783c
Christian Brabandt <cb@256bit.org>
parents: 10048
diff changeset
256 hi def link plsqlSymbol Normal
46763b01cd9a commit https://github.com/vim/vim/commit/f37506f60f87d52a9e8850e30067645e2b13783c
Christian Brabandt <cb@256bit.org>
parents: 10048
diff changeset
257 hi def link plsqlTrigger Function
46763b01cd9a commit https://github.com/vim/vim/commit/f37506f60f87d52a9e8850e30067645e2b13783c
Christian Brabandt <cb@256bit.org>
parents: 10048
diff changeset
258 hi def link plsqlTypeAttribute StorageClass
46763b01cd9a commit https://github.com/vim/vim/commit/f37506f60f87d52a9e8850e30067645e2b13783c
Christian Brabandt <cb@256bit.org>
parents: 10048
diff changeset
259 hi def link plsqlTodo Todo
7
3fc0f57ecb91 updated for version 7.0001
vimboss
parents:
diff changeset
260
3fc0f57ecb91 updated for version 7.0001
vimboss
parents:
diff changeset
261
3fc0f57ecb91 updated for version 7.0001
vimboss
parents:
diff changeset
262 let b:current_syntax = "plsql"
3fc0f57ecb91 updated for version 7.0001
vimboss
parents:
diff changeset
263
3fc0f57ecb91 updated for version 7.0001
vimboss
parents:
diff changeset
264 " vim: ts=8 sw=2