Mercurial > hg > RemoteEditor > vim7

comparison runtime/syntax/plsql.vim @ 0:76efa0be13f1

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