Mercurial > vim

annotate runtime/syntax/sqloracle.vim @ 9644:9f7bcc2c3b97

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
commit https://github.com/vim/vim/commit/6f1d9a096bf22d50c727dca73abbfb8e3ff55176 Author: Bram Moolenaar <Bram@vim.org> Date: Sun Jul 24 14:12:38 2016 +0200 Updated runtime files.
author Christian Brabandt <cb@256bit.org>
date Sun, 24 Jul 2016 14:15:06 +0200
parents 17333ebd2bbd
children 46763b01cd9a
Ignore whitespace changes - Everywhere: Within whitespace: At end of lines:
rev   line source
720
e180933b876a updated for version 7.0219
vimboss
parents:
diff changeset
1 " Vim syntax file
7272
17333ebd2bbd commit https://github.com/vim/vim/commit/d042dc825c9b97dacd84d4728f88300da4d5b6b9
Christian Brabandt <cb@256bit.org>
parents: 720
diff changeset
2 " Language: SQL, PL/SQL (Oracle 11g)
17333ebd2bbd commit https://github.com/vim/vim/commit/d042dc825c9b97dacd84d4728f88300da4d5b6b9
Christian Brabandt <cb@256bit.org>
parents: 720
diff changeset
3 " Maintainer: Christian Brabandt
17333ebd2bbd commit https://github.com/vim/vim/commit/d042dc825c9b97dacd84d4728f88300da4d5b6b9
Christian Brabandt <cb@256bit.org>
parents: 720
diff changeset
4 " Repository: https://github.com/chrisbra/vim-sqloracle-syntax
17333ebd2bbd commit https://github.com/vim/vim/commit/d042dc825c9b97dacd84d4728f88300da4d5b6b9
Christian Brabandt <cb@256bit.org>
parents: 720
diff changeset
5 " License: Vim
17333ebd2bbd commit https://github.com/vim/vim/commit/d042dc825c9b97dacd84d4728f88300da4d5b6b9
Christian Brabandt <cb@256bit.org>
parents: 720
diff changeset
6 " Previous Maintainer: Paul Moore
9644
9f7bcc2c3b97 commit https://github.com/vim/vim/commit/6f1d9a096bf22d50c727dca73abbfb8e3ff55176
Christian Brabandt <cb@256bit.org>
parents: 7272
diff changeset
7 " Last Change: 2016 Jul 22
9f7bcc2c3b97 commit https://github.com/vim/vim/commit/6f1d9a096bf22d50c727dca73abbfb8e3ff55176
Christian Brabandt <cb@256bit.org>
parents: 7272
diff changeset
8
9f7bcc2c3b97 commit https://github.com/vim/vim/commit/6f1d9a096bf22d50c727dca73abbfb8e3ff55176
Christian Brabandt <cb@256bit.org>
parents: 7272
diff changeset
9 " Changes:
9f7bcc2c3b97 commit https://github.com/vim/vim/commit/6f1d9a096bf22d50c727dca73abbfb8e3ff55176
Christian Brabandt <cb@256bit.org>
parents: 7272
diff changeset
10 " 02.04.2016: Support for when keyword
9f7bcc2c3b97 commit https://github.com/vim/vim/commit/6f1d9a096bf22d50c727dca73abbfb8e3ff55176
Christian Brabandt <cb@256bit.org>
parents: 7272
diff changeset
11 " 03.04.2016: Support for join related keywords
9f7bcc2c3b97 commit https://github.com/vim/vim/commit/6f1d9a096bf22d50c727dca73abbfb8e3ff55176
Christian Brabandt <cb@256bit.org>
parents: 7272
diff changeset
12 " 22.07.2016: Support Oracle Q-Quote-Syntax
720
e180933b876a updated for version 7.0219
vimboss
parents:
diff changeset
13
7272
17333ebd2bbd commit https://github.com/vim/vim/commit/d042dc825c9b97dacd84d4728f88300da4d5b6b9
Christian Brabandt <cb@256bit.org>
parents: 720
diff changeset
14 if exists("b:current_syntax")
720
e180933b876a updated for version 7.0219
vimboss
parents:
diff changeset
15 finish
e180933b876a updated for version 7.0219
vimboss
parents:
diff changeset
16 endif
e180933b876a updated for version 7.0219
vimboss
parents:
diff changeset
17
e180933b876a updated for version 7.0219
vimboss
parents:
diff changeset
18 syn case ignore
e180933b876a updated for version 7.0219
vimboss
parents:
diff changeset
19
e180933b876a updated for version 7.0219
vimboss
parents:
diff changeset
20 " The SQL reserved words, defined as keywords.
e180933b876a updated for version 7.0219
vimboss
parents:
diff changeset
21
7272
17333ebd2bbd commit https://github.com/vim/vim/commit/d042dc825c9b97dacd84d4728f88300da4d5b6b9
Christian Brabandt <cb@256bit.org>
parents: 720
diff changeset
22 syn keyword sqlSpecial false null true
720
e180933b876a updated for version 7.0219
vimboss
parents:
diff changeset
23
7272
17333ebd2bbd commit https://github.com/vim/vim/commit/d042dc825c9b97dacd84d4728f88300da4d5b6b9
Christian Brabandt <cb@256bit.org>
parents: 720
diff changeset
24 syn keyword sqlKeyword access add as asc begin by case check cluster column
17333ebd2bbd commit https://github.com/vim/vim/commit/d042dc825c9b97dacd84d4728f88300da4d5b6b9
Christian Brabandt <cb@256bit.org>
parents: 720
diff changeset
25 syn keyword sqlKeyword cache compress connect current cursor decimal default desc
720
e180933b876a updated for version 7.0219
vimboss
parents:
diff changeset
26 syn keyword sqlKeyword else elsif end exception exclusive file for from
e180933b876a updated for version 7.0219
vimboss
parents:
diff changeset
27 syn keyword sqlKeyword function group having identified if immediate increment
7272
17333ebd2bbd commit https://github.com/vim/vim/commit/d042dc825c9b97dacd84d4728f88300da4d5b6b9
Christian Brabandt <cb@256bit.org>
parents: 720
diff changeset
28 syn keyword sqlKeyword index initial initrans into is level link logging loop
17333ebd2bbd commit https://github.com/vim/vim/commit/d042dc825c9b97dacd84d4728f88300da4d5b6b9
Christian Brabandt <cb@256bit.org>
parents: 720
diff changeset
29 syn keyword sqlKeyword maxextents maxtrans mode modify monitoring
17333ebd2bbd commit https://github.com/vim/vim/commit/d042dc825c9b97dacd84d4728f88300da4d5b6b9
Christian Brabandt <cb@256bit.org>
parents: 720
diff changeset
30 syn keyword sqlKeyword nocache nocompress nologging noparallel nowait of offline on online start
17333ebd2bbd commit https://github.com/vim/vim/commit/d042dc825c9b97dacd84d4728f88300da4d5b6b9
Christian Brabandt <cb@256bit.org>
parents: 720
diff changeset
31 syn keyword sqlKeyword parallel successful synonym table tablespace then to trigger uid
9644
9f7bcc2c3b97 commit https://github.com/vim/vim/commit/6f1d9a096bf22d50c727dca73abbfb8e3ff55176
Christian Brabandt <cb@256bit.org>
parents: 7272
diff changeset
32 syn keyword sqlKeyword unique user validate values view when whenever
7272
17333ebd2bbd commit https://github.com/vim/vim/commit/d042dc825c9b97dacd84d4728f88300da4d5b6b9
Christian Brabandt <cb@256bit.org>
parents: 720
diff changeset
33 syn keyword sqlKeyword where with option order pctfree pctused privileges procedure
720
e180933b876a updated for version 7.0219
vimboss
parents:
diff changeset
34 syn keyword sqlKeyword public resource return row rowlabel rownum rows
e180933b876a updated for version 7.0219
vimboss
parents:
diff changeset
35 syn keyword sqlKeyword session share size smallint type using
9644
9f7bcc2c3b97 commit https://github.com/vim/vim/commit/6f1d9a096bf22d50c727dca73abbfb8e3ff55176
Christian Brabandt <cb@256bit.org>
parents: 7272
diff changeset
36 syn keyword sqlKeyword join cross inner outer left right
720
e180933b876a updated for version 7.0219
vimboss
parents:
diff changeset
37
e180933b876a updated for version 7.0219
vimboss
parents:
diff changeset
38 syn keyword sqlOperator not and or
e180933b876a updated for version 7.0219
vimboss
parents:
diff changeset
39 syn keyword sqlOperator in any some all between exists
e180933b876a updated for version 7.0219
vimboss
parents:
diff changeset
40 syn keyword sqlOperator like escape
7272
17333ebd2bbd commit https://github.com/vim/vim/commit/d042dc825c9b97dacd84d4728f88300da4d5b6b9
Christian Brabandt <cb@256bit.org>
parents: 720
diff changeset
41 syn keyword sqlOperator union intersect minus
17333ebd2bbd commit https://github.com/vim/vim/commit/d042dc825c9b97dacd84d4728f88300da4d5b6b9
Christian Brabandt <cb@256bit.org>
parents: 720
diff changeset
42 syn keyword sqlOperator prior distinct
720
e180933b876a updated for version 7.0219
vimboss
parents:
diff changeset
43 syn keyword sqlOperator sysdate out
e180933b876a updated for version 7.0219
vimboss
parents:
diff changeset
44
7272
17333ebd2bbd commit https://github.com/vim/vim/commit/d042dc825c9b97dacd84d4728f88300da4d5b6b9
Christian Brabandt <cb@256bit.org>
parents: 720
diff changeset
45 syn keyword sqlStatement analyze audit comment commit
17333ebd2bbd commit https://github.com/vim/vim/commit/d042dc825c9b97dacd84d4728f88300da4d5b6b9
Christian Brabandt <cb@256bit.org>
parents: 720
diff changeset
46 syn keyword sqlStatement delete drop execute explain grant lock noaudit
17333ebd2bbd commit https://github.com/vim/vim/commit/d042dc825c9b97dacd84d4728f88300da4d5b6b9
Christian Brabandt <cb@256bit.org>
parents: 720
diff changeset
47 syn keyword sqlStatement rename revoke rollback savepoint set
17333ebd2bbd commit https://github.com/vim/vim/commit/d042dc825c9b97dacd84d4728f88300da4d5b6b9
Christian Brabandt <cb@256bit.org>
parents: 720
diff changeset
48 syn keyword sqlStatement truncate
17333ebd2bbd commit https://github.com/vim/vim/commit/d042dc825c9b97dacd84d4728f88300da4d5b6b9
Christian Brabandt <cb@256bit.org>
parents: 720
diff changeset
49 " next ones are contained, so folding works.
17333ebd2bbd commit https://github.com/vim/vim/commit/d042dc825c9b97dacd84d4728f88300da4d5b6b9
Christian Brabandt <cb@256bit.org>
parents: 720
diff changeset
50 syn keyword sqlStatement create update alter select insert contained
720
e180933b876a updated for version 7.0219
vimboss
parents:
diff changeset
51
e180933b876a updated for version 7.0219
vimboss
parents:
diff changeset
52 syn keyword sqlType boolean char character date float integer long
e180933b876a updated for version 7.0219
vimboss
parents:
diff changeset
53 syn keyword sqlType mlslabel number raw rowid varchar varchar2 varray
e180933b876a updated for version 7.0219
vimboss
parents:
diff changeset
54
7272
17333ebd2bbd commit https://github.com/vim/vim/commit/d042dc825c9b97dacd84d4728f88300da4d5b6b9
Christian Brabandt <cb@256bit.org>
parents: 720
diff changeset
55 " Strings:
9644
9f7bcc2c3b97 commit https://github.com/vim/vim/commit/6f1d9a096bf22d50c727dca73abbfb8e3ff55176
Christian Brabandt <cb@256bit.org>
parents: 7272
diff changeset
56 syn region sqlString matchgroup=Quote start=+"+ skip=+\\\\\|\\"+ end=+"+
9f7bcc2c3b97 commit https://github.com/vim/vim/commit/6f1d9a096bf22d50c727dca73abbfb8e3ff55176
Christian Brabandt <cb@256bit.org>
parents: 7272
diff changeset
57 syn region sqlString matchgroup=Quote start=+'+ skip=+\\\\\|\\'+ end=+'+
9f7bcc2c3b97 commit https://github.com/vim/vim/commit/6f1d9a096bf22d50c727dca73abbfb8e3ff55176
Christian Brabandt <cb@256bit.org>
parents: 7272
diff changeset
58 syn region sqlString matchgroup=Quote start=+n\?q'\z([^[(<{]\)+ end=+\z1'+
9f7bcc2c3b97 commit https://github.com/vim/vim/commit/6f1d9a096bf22d50c727dca73abbfb8e3ff55176
Christian Brabandt <cb@256bit.org>
parents: 7272
diff changeset
59 syn region sqlString matchgroup=Quote start=+n\?q'<+ end=+>'+
9f7bcc2c3b97 commit https://github.com/vim/vim/commit/6f1d9a096bf22d50c727dca73abbfb8e3ff55176
Christian Brabandt <cb@256bit.org>
parents: 7272
diff changeset
60 syn region sqlString matchgroup=Quote start=+n\?q'{+ end=+}'+
9f7bcc2c3b97 commit https://github.com/vim/vim/commit/6f1d9a096bf22d50c727dca73abbfb8e3ff55176
Christian Brabandt <cb@256bit.org>
parents: 7272
diff changeset
61 syn region sqlString matchgroup=Quote start=+n\?q'(+ end=+)'+
9f7bcc2c3b97 commit https://github.com/vim/vim/commit/6f1d9a096bf22d50c727dca73abbfb8e3ff55176
Christian Brabandt <cb@256bit.org>
parents: 7272
diff changeset
62 syn region sqlString matchgroup=Quote start=+n\?q'\[+ end=+]'+
720
e180933b876a updated for version 7.0219
vimboss
parents:
diff changeset
63
e180933b876a updated for version 7.0219
vimboss
parents:
diff changeset
64 " Numbers:
7272
17333ebd2bbd commit https://github.com/vim/vim/commit/d042dc825c9b97dacd84d4728f88300da4d5b6b9
Christian Brabandt <cb@256bit.org>
parents: 720
diff changeset
65 syn match sqlNumber "-\=\<\d*\.\=[0-9_]\>"
720
e180933b876a updated for version 7.0219
vimboss
parents:
diff changeset
66
e180933b876a updated for version 7.0219
vimboss
parents:
diff changeset
67 " Comments:
7272
17333ebd2bbd commit https://github.com/vim/vim/commit/d042dc825c9b97dacd84d4728f88300da4d5b6b9
Christian Brabandt <cb@256bit.org>
parents: 720
diff changeset
68 syn region sqlComment start="/\*" end="\*/" contains=sqlTodo,@Spell fold
17333ebd2bbd commit https://github.com/vim/vim/commit/d042dc825c9b97dacd84d4728f88300da4d5b6b9
Christian Brabandt <cb@256bit.org>
parents: 720
diff changeset
69 syn match sqlComment "--.*$" contains=sqlTodo,@Spell
17333ebd2bbd commit https://github.com/vim/vim/commit/d042dc825c9b97dacd84d4728f88300da4d5b6b9
Christian Brabandt <cb@256bit.org>
parents: 720
diff changeset
70
17333ebd2bbd commit https://github.com/vim/vim/commit/d042dc825c9b97dacd84d4728f88300da4d5b6b9
Christian Brabandt <cb@256bit.org>
parents: 720
diff changeset
71 " Setup Folding:
17333ebd2bbd commit https://github.com/vim/vim/commit/d042dc825c9b97dacd84d4728f88300da4d5b6b9
Christian Brabandt <cb@256bit.org>
parents: 720
diff changeset
72 " this is a hack, to get certain statements folded.
17333ebd2bbd commit https://github.com/vim/vim/commit/d042dc825c9b97dacd84d4728f88300da4d5b6b9
Christian Brabandt <cb@256bit.org>
parents: 720
diff changeset
73 " the keywords create/update/alter/select/insert need to
17333ebd2bbd commit https://github.com/vim/vim/commit/d042dc825c9b97dacd84d4728f88300da4d5b6b9
Christian Brabandt <cb@256bit.org>
parents: 720
diff changeset
74 " have contained option.
17333ebd2bbd commit https://github.com/vim/vim/commit/d042dc825c9b97dacd84d4728f88300da4d5b6b9
Christian Brabandt <cb@256bit.org>
parents: 720
diff changeset
75 syn region sqlFold start='^\s*\zs\c\(Create\|Update\|Alter\|Select\|Insert\)' end=';$\|^$' transparent fold contains=ALL
720
e180933b876a updated for version 7.0219
vimboss
parents:
diff changeset
76
e180933b876a updated for version 7.0219
vimboss
parents:
diff changeset
77 syn sync ccomment sqlComment
e180933b876a updated for version 7.0219
vimboss
parents:
diff changeset
78
7272
17333ebd2bbd commit https://github.com/vim/vim/commit/d042dc825c9b97dacd84d4728f88300da4d5b6b9
Christian Brabandt <cb@256bit.org>
parents: 720
diff changeset
79 " Functions:
17333ebd2bbd commit https://github.com/vim/vim/commit/d042dc825c9b97dacd84d4728f88300da4d5b6b9
Christian Brabandt <cb@256bit.org>
parents: 720
diff changeset
80 " (Oracle 11g)
17333ebd2bbd commit https://github.com/vim/vim/commit/d042dc825c9b97dacd84d4728f88300da4d5b6b9
Christian Brabandt <cb@256bit.org>
parents: 720
diff changeset
81 " Aggregate Functions
17333ebd2bbd commit https://github.com/vim/vim/commit/d042dc825c9b97dacd84d4728f88300da4d5b6b9
Christian Brabandt <cb@256bit.org>
parents: 720
diff changeset
82 syn keyword sqlFunction avg collect corr corr_s corr_k count covar_pop covar_samp cume_dist dense_rank first
17333ebd2bbd commit https://github.com/vim/vim/commit/d042dc825c9b97dacd84d4728f88300da4d5b6b9
Christian Brabandt <cb@256bit.org>
parents: 720
diff changeset
83 syn keyword sqlFunction group_id grouping grouping_id last max median min percentile_cont percentile_disc percent_rank rank
17333ebd2bbd commit https://github.com/vim/vim/commit/d042dc825c9b97dacd84d4728f88300da4d5b6b9
Christian Brabandt <cb@256bit.org>
parents: 720
diff changeset
84 syn keyword sqlFunction regr_slope regr_intercept regr_count regr_r2 regr_avgx regr_avgy regr_sxx regr_syy regr_sxy
17333ebd2bbd commit https://github.com/vim/vim/commit/d042dc825c9b97dacd84d4728f88300da4d5b6b9
Christian Brabandt <cb@256bit.org>
parents: 720
diff changeset
85 syn keyword sqlFunction stats_binomial_test stats_crosstab stats_f_test stats_ks_test stats_mode stats_mw_test
17333ebd2bbd commit https://github.com/vim/vim/commit/d042dc825c9b97dacd84d4728f88300da4d5b6b9
Christian Brabandt <cb@256bit.org>
parents: 720
diff changeset
86 syn keyword sqlFunction stats_one_way_anova stats_t_test_one stats_t_test_paired stats_t_test_indep stats_t_test_indepu
17333ebd2bbd commit https://github.com/vim/vim/commit/d042dc825c9b97dacd84d4728f88300da4d5b6b9
Christian Brabandt <cb@256bit.org>
parents: 720
diff changeset
87 syn keyword sqlFunction stats_wsr_test stddev stddev_pop stddev_samp sum
17333ebd2bbd commit https://github.com/vim/vim/commit/d042dc825c9b97dacd84d4728f88300da4d5b6b9
Christian Brabandt <cb@256bit.org>
parents: 720
diff changeset
88 syn keyword sqlFunction sys_xmlagg var_pop var_samp variance xmlagg
17333ebd2bbd commit https://github.com/vim/vim/commit/d042dc825c9b97dacd84d4728f88300da4d5b6b9
Christian Brabandt <cb@256bit.org>
parents: 720
diff changeset
89 " Char Functions
17333ebd2bbd commit https://github.com/vim/vim/commit/d042dc825c9b97dacd84d4728f88300da4d5b6b9
Christian Brabandt <cb@256bit.org>
parents: 720
diff changeset
90 syn keyword sqlFunction ascii chr concat initcap instr length lower lpad ltrim
17333ebd2bbd commit https://github.com/vim/vim/commit/d042dc825c9b97dacd84d4728f88300da4d5b6b9
Christian Brabandt <cb@256bit.org>
parents: 720
diff changeset
91 syn keyword sqlFunction nls_initcap nls_lower nlssort nls_upper regexp_instr regexp_replace
17333ebd2bbd commit https://github.com/vim/vim/commit/d042dc825c9b97dacd84d4728f88300da4d5b6b9
Christian Brabandt <cb@256bit.org>
parents: 720
diff changeset
92 syn keyword sqlFunction regexp_substr replace rpad rtrim soundex substr translate treat trim upper
17333ebd2bbd commit https://github.com/vim/vim/commit/d042dc825c9b97dacd84d4728f88300da4d5b6b9
Christian Brabandt <cb@256bit.org>
parents: 720
diff changeset
93 " Comparison Functions
17333ebd2bbd commit https://github.com/vim/vim/commit/d042dc825c9b97dacd84d4728f88300da4d5b6b9
Christian Brabandt <cb@256bit.org>
parents: 720
diff changeset
94 syn keyword sqlFunction greatest least
17333ebd2bbd commit https://github.com/vim/vim/commit/d042dc825c9b97dacd84d4728f88300da4d5b6b9
Christian Brabandt <cb@256bit.org>
parents: 720
diff changeset
95 " Conversion Functions
17333ebd2bbd commit https://github.com/vim/vim/commit/d042dc825c9b97dacd84d4728f88300da4d5b6b9
Christian Brabandt <cb@256bit.org>
parents: 720
diff changeset
96 syn keyword sqlFunction asciistr bin_to_num cast chartorowid compose convert
17333ebd2bbd commit https://github.com/vim/vim/commit/d042dc825c9b97dacd84d4728f88300da4d5b6b9
Christian Brabandt <cb@256bit.org>
parents: 720
diff changeset
97 syn keyword sqlFunction decompose hextoraw numtodsinterval numtoyminterval rawtohex rawtonhex rowidtochar
17333ebd2bbd commit https://github.com/vim/vim/commit/d042dc825c9b97dacd84d4728f88300da4d5b6b9
Christian Brabandt <cb@256bit.org>
parents: 720
diff changeset
98 syn keyword sqlFunction rowidtonchar scn_to_timestamp timestamp_to_scn to_binary_double to_binary_float
17333ebd2bbd commit https://github.com/vim/vim/commit/d042dc825c9b97dacd84d4728f88300da4d5b6b9
Christian Brabandt <cb@256bit.org>
parents: 720
diff changeset
99 syn keyword sqlFunction to_char to_char to_char to_clob to_date to_dsinterval to_lob to_multi_byte
17333ebd2bbd commit https://github.com/vim/vim/commit/d042dc825c9b97dacd84d4728f88300da4d5b6b9
Christian Brabandt <cb@256bit.org>
parents: 720
diff changeset
100 syn keyword sqlFunction to_nchar to_nchar to_nchar to_nclob to_number to_dsinterval to_single_byte
17333ebd2bbd commit https://github.com/vim/vim/commit/d042dc825c9b97dacd84d4728f88300da4d5b6b9
Christian Brabandt <cb@256bit.org>
parents: 720
diff changeset
101 syn keyword sqlFunction to_timestamp to_timestamp_tz to_yminterval to_yminterval translate unistr
17333ebd2bbd commit https://github.com/vim/vim/commit/d042dc825c9b97dacd84d4728f88300da4d5b6b9
Christian Brabandt <cb@256bit.org>
parents: 720
diff changeset
102 " DataMining Functions
17333ebd2bbd commit https://github.com/vim/vim/commit/d042dc825c9b97dacd84d4728f88300da4d5b6b9
Christian Brabandt <cb@256bit.org>
parents: 720
diff changeset
103 syn keyword sqlFunction cluster_id cluster_probability cluster_set feature_id feature_set
17333ebd2bbd commit https://github.com/vim/vim/commit/d042dc825c9b97dacd84d4728f88300da4d5b6b9
Christian Brabandt <cb@256bit.org>
parents: 720
diff changeset
104 syn keyword sqlFunction feature_value prediction prediction_bounds prediction_cost
17333ebd2bbd commit https://github.com/vim/vim/commit/d042dc825c9b97dacd84d4728f88300da4d5b6b9
Christian Brabandt <cb@256bit.org>
parents: 720
diff changeset
105 syn keyword sqlFunction prediction_details prediction_probability prediction_set
17333ebd2bbd commit https://github.com/vim/vim/commit/d042dc825c9b97dacd84d4728f88300da4d5b6b9
Christian Brabandt <cb@256bit.org>
parents: 720
diff changeset
106 " Datetime Functions
17333ebd2bbd commit https://github.com/vim/vim/commit/d042dc825c9b97dacd84d4728f88300da4d5b6b9
Christian Brabandt <cb@256bit.org>
parents: 720
diff changeset
107 syn keyword sqlFunction add_months current_date current_timestamp dbtimezone extract
17333ebd2bbd commit https://github.com/vim/vim/commit/d042dc825c9b97dacd84d4728f88300da4d5b6b9
Christian Brabandt <cb@256bit.org>
parents: 720
diff changeset
108 syn keyword sqlFunction from_tz last_day localtimestamp months_between new_time
17333ebd2bbd commit https://github.com/vim/vim/commit/d042dc825c9b97dacd84d4728f88300da4d5b6b9
Christian Brabandt <cb@256bit.org>
parents: 720
diff changeset
109 syn keyword sqlFunction next_day numtodsinterval numtoyminterval round sessiontimezone
17333ebd2bbd commit https://github.com/vim/vim/commit/d042dc825c9b97dacd84d4728f88300da4d5b6b9
Christian Brabandt <cb@256bit.org>
parents: 720
diff changeset
110 syn keyword sqlFunction sys_extract_utc sysdate systimestamp to_char to_timestamp
17333ebd2bbd commit https://github.com/vim/vim/commit/d042dc825c9b97dacd84d4728f88300da4d5b6b9
Christian Brabandt <cb@256bit.org>
parents: 720
diff changeset
111 syn keyword sqlFunction to_timestamp_tz to_dsinterval to_yminterval trunc tz_offset
17333ebd2bbd commit https://github.com/vim/vim/commit/d042dc825c9b97dacd84d4728f88300da4d5b6b9
Christian Brabandt <cb@256bit.org>
parents: 720
diff changeset
112 " Numeric Functions
17333ebd2bbd commit https://github.com/vim/vim/commit/d042dc825c9b97dacd84d4728f88300da4d5b6b9
Christian Brabandt <cb@256bit.org>
parents: 720
diff changeset
113 syn keyword sqlFunction abs acos asin atan atan2 bitand ceil cos cosh exp
17333ebd2bbd commit https://github.com/vim/vim/commit/d042dc825c9b97dacd84d4728f88300da4d5b6b9
Christian Brabandt <cb@256bit.org>
parents: 720
diff changeset
114 syn keyword sqlFunction floor ln log mod nanvl power remainder round sign
17333ebd2bbd commit https://github.com/vim/vim/commit/d042dc825c9b97dacd84d4728f88300da4d5b6b9
Christian Brabandt <cb@256bit.org>
parents: 720
diff changeset
115 syn keyword sqlFunction sin sinh sqrt tan tanh trunc width_bucket
17333ebd2bbd commit https://github.com/vim/vim/commit/d042dc825c9b97dacd84d4728f88300da4d5b6b9
Christian Brabandt <cb@256bit.org>
parents: 720
diff changeset
116 " NLS Functions
17333ebd2bbd commit https://github.com/vim/vim/commit/d042dc825c9b97dacd84d4728f88300da4d5b6b9
Christian Brabandt <cb@256bit.org>
parents: 720
diff changeset
117 syn keyword sqlFunction ls_charset_decl_len nls_charset_id nls_charset_name
17333ebd2bbd commit https://github.com/vim/vim/commit/d042dc825c9b97dacd84d4728f88300da4d5b6b9
Christian Brabandt <cb@256bit.org>
parents: 720
diff changeset
118 " Various Functions
17333ebd2bbd commit https://github.com/vim/vim/commit/d042dc825c9b97dacd84d4728f88300da4d5b6b9
Christian Brabandt <cb@256bit.org>
parents: 720
diff changeset
119 syn keyword sqlFunction bfilename cardin coalesce collect decode dump empty_blob empty_clob
17333ebd2bbd commit https://github.com/vim/vim/commit/d042dc825c9b97dacd84d4728f88300da4d5b6b9
Christian Brabandt <cb@256bit.org>
parents: 720
diff changeset
120 syn keyword sqlFunction lnnvl nullif nvl nvl2 ora_hash powermultiset powermultiset_by_cardinality
17333ebd2bbd commit https://github.com/vim/vim/commit/d042dc825c9b97dacd84d4728f88300da4d5b6b9
Christian Brabandt <cb@256bit.org>
parents: 720
diff changeset
121 syn keyword sqlFunction sys_connect_by_path sys_context sys_guid sys_typeid uid user userenv vsizeality
17333ebd2bbd commit https://github.com/vim/vim/commit/d042dc825c9b97dacd84d4728f88300da4d5b6b9
Christian Brabandt <cb@256bit.org>
parents: 720
diff changeset
122 " XML Functions
17333ebd2bbd commit https://github.com/vim/vim/commit/d042dc825c9b97dacd84d4728f88300da4d5b6b9
Christian Brabandt <cb@256bit.org>
parents: 720
diff changeset
123 syn keyword sqlFunction appendchildxml deletexml depth extract existsnode extractvalue insertchildxml
17333ebd2bbd commit https://github.com/vim/vim/commit/d042dc825c9b97dacd84d4728f88300da4d5b6b9
Christian Brabandt <cb@256bit.org>
parents: 720
diff changeset
124 syn keyword sqlFunction insertxmlbefore path sys_dburigen sys_xmlagg sys_xmlgen updatexml xmlagg xmlcast
17333ebd2bbd commit https://github.com/vim/vim/commit/d042dc825c9b97dacd84d4728f88300da4d5b6b9
Christian Brabandt <cb@256bit.org>
parents: 720
diff changeset
125 syn keyword sqlFunction xmlcdata xmlcolattval xmlcomment xmlconcat xmldiff xmlelement xmlexists xmlforest
17333ebd2bbd commit https://github.com/vim/vim/commit/d042dc825c9b97dacd84d4728f88300da4d5b6b9
Christian Brabandt <cb@256bit.org>
parents: 720
diff changeset
126 syn keyword sqlFunction xmlparse xmlpatch xmlpi xmlquery xmlroot xmlsequence xmlserialize xmltable xmltransform
17333ebd2bbd commit https://github.com/vim/vim/commit/d042dc825c9b97dacd84d4728f88300da4d5b6b9
Christian Brabandt <cb@256bit.org>
parents: 720
diff changeset
127 " Todo:
17333ebd2bbd commit https://github.com/vim/vim/commit/d042dc825c9b97dacd84d4728f88300da4d5b6b9
Christian Brabandt <cb@256bit.org>
parents: 720
diff changeset
128 syn keyword sqlTodo TODO FIXME XXX DEBUG NOTE contained
720
e180933b876a updated for version 7.0219
vimboss
parents:
diff changeset
129
e180933b876a updated for version 7.0219
vimboss
parents:
diff changeset
130 " Define the default highlighting.
7272
17333ebd2bbd commit https://github.com/vim/vim/commit/d042dc825c9b97dacd84d4728f88300da4d5b6b9
Christian Brabandt <cb@256bit.org>
parents: 720
diff changeset
131 command -nargs=+ HiLink hi def link <args>
9644
9f7bcc2c3b97 commit https://github.com/vim/vim/commit/6f1d9a096bf22d50c727dca73abbfb8e3ff55176
Christian Brabandt <cb@256bit.org>
parents: 7272
diff changeset
132 HiLink Quote Special
7272
17333ebd2bbd commit https://github.com/vim/vim/commit/d042dc825c9b97dacd84d4728f88300da4d5b6b9
Christian Brabandt <cb@256bit.org>
parents: 720
diff changeset
133 HiLink sqlComment Comment
17333ebd2bbd commit https://github.com/vim/vim/commit/d042dc825c9b97dacd84d4728f88300da4d5b6b9
Christian Brabandt <cb@256bit.org>
parents: 720
diff changeset
134 HiLink sqlFunction Function
17333ebd2bbd commit https://github.com/vim/vim/commit/d042dc825c9b97dacd84d4728f88300da4d5b6b9
Christian Brabandt <cb@256bit.org>
parents: 720
diff changeset
135 HiLink sqlKeyword sqlSpecial
17333ebd2bbd commit https://github.com/vim/vim/commit/d042dc825c9b97dacd84d4728f88300da4d5b6b9
Christian Brabandt <cb@256bit.org>
parents: 720
diff changeset
136 HiLink sqlNumber Number
17333ebd2bbd commit https://github.com/vim/vim/commit/d042dc825c9b97dacd84d4728f88300da4d5b6b9
Christian Brabandt <cb@256bit.org>
parents: 720
diff changeset
137 HiLink sqlOperator sqlStatement
17333ebd2bbd commit https://github.com/vim/vim/commit/d042dc825c9b97dacd84d4728f88300da4d5b6b9
Christian Brabandt <cb@256bit.org>
parents: 720
diff changeset
138 HiLink sqlSpecial Special
17333ebd2bbd commit https://github.com/vim/vim/commit/d042dc825c9b97dacd84d4728f88300da4d5b6b9
Christian Brabandt <cb@256bit.org>
parents: 720
diff changeset
139 HiLink sqlStatement Statement
17333ebd2bbd commit https://github.com/vim/vim/commit/d042dc825c9b97dacd84d4728f88300da4d5b6b9
Christian Brabandt <cb@256bit.org>
parents: 720
diff changeset
140 HiLink sqlString String
17333ebd2bbd commit https://github.com/vim/vim/commit/d042dc825c9b97dacd84d4728f88300da4d5b6b9
Christian Brabandt <cb@256bit.org>
parents: 720
diff changeset
141 HiLink sqlType Type
17333ebd2bbd commit https://github.com/vim/vim/commit/d042dc825c9b97dacd84d4728f88300da4d5b6b9
Christian Brabandt <cb@256bit.org>
parents: 720
diff changeset
142 HiLink sqlTodo Todo
720
e180933b876a updated for version 7.0219
vimboss
parents:
diff changeset
143
7272
17333ebd2bbd commit https://github.com/vim/vim/commit/d042dc825c9b97dacd84d4728f88300da4d5b6b9
Christian Brabandt <cb@256bit.org>
parents: 720
diff changeset
144 delcommand HiLink
720
e180933b876a updated for version 7.0219
vimboss
parents:
diff changeset
145 let b:current_syntax = "sql"
e180933b876a updated for version 7.0219
vimboss
parents:
diff changeset
146 " vim: ts=8