Mercurial > vim

annotate runtime/syntax/sqloracle.vim @ 33480:f8dd278ab05f v9.0.1991

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
patch 9.0.1991: no cmdline completion for setting the font Commit: https://github.com/vim/vim/commit/290b887e8cc2c0d3dfc7f315b2052472c7c589cc Author: Yee Cheng Chin <ychin.git@gmail.com> Date: Thu Oct 5 20:54:21 2023 +0200 patch 9.0.1991: no cmdline completion for setting the font Problem: no cmdline completion for setting the font Solution: enable it on Win32 and GTK builds Add guifont cmdline completion (for Windows and GTK) For Windows, auto-complete will only suggest monospace fonts as that's the only types allowed. Will also suggest font options after the colon, including suggesting the current font size for convenience, and misc charset and quality options like `cANSI` and `qCLEARTYPE`. For GTK, auto-complete will suggest only monospace fonts for `guifont` but will include all fonts for `guifontwide`. The completion code doesn't currently suggest the current font size, as the GTK guifont format does not have a clear delimiter (':' for other platforms). closes: #13264 Signed-off-by: Christian Brabandt <cb@256bit.org> Co-authored-by: Yee Cheng Chin <ychin.git@gmail.com>
author Christian Brabandt <cb@256bit.org>
date Thu, 05 Oct 2023 21:00:07 +0200
parents c460506890ba
children
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
14193
c460506890ba Update runtime files.
Christian Brabandt <cb@256bit.org>
parents: 13937
diff changeset
7 " Last Change: 2018 June 24
9644
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
13937
cd513458728c Updated runtime files
Christian Brabandt <cb@256bit.org>
parents: 10051
diff changeset
13 " 25.07.2016: Support for Oracle N'-Quote syntax
14193
c460506890ba Update runtime files.
Christian Brabandt <cb@256bit.org>
parents: 13937
diff changeset
14 " 22.06.2018: Remove skip part for sqlString (do not escape strings)
c460506890ba Update runtime files.
Christian Brabandt <cb@256bit.org>
parents: 13937
diff changeset
15 " (https://web.archive.org/web/20150922065035/https://mariadb.com/kb/en/sql-99/character-string-literals/)
720
e180933b876a updated for version 7.0219
vimboss
parents:
diff changeset
16
7272
17333ebd2bbd commit https://github.com/vim/vim/commit/d042dc825c9b97dacd84d4728f88300da4d5b6b9
Christian Brabandt <cb@256bit.org>
parents: 720
diff changeset
17 if exists("b:current_syntax")
720
e180933b876a updated for version 7.0219
vimboss
parents:
diff changeset
18 finish
e180933b876a updated for version 7.0219
vimboss
parents:
diff changeset
19 endif
e180933b876a updated for version 7.0219
vimboss
parents:
diff changeset
20
e180933b876a updated for version 7.0219
vimboss
parents:
diff changeset
21 syn case ignore
e180933b876a updated for version 7.0219
vimboss
parents:
diff changeset
22
e180933b876a updated for version 7.0219
vimboss
parents:
diff changeset
23 " The SQL reserved words, defined as keywords.
e180933b876a updated for version 7.0219
vimboss
parents:
diff changeset
24
7272
17333ebd2bbd commit https://github.com/vim/vim/commit/d042dc825c9b97dacd84d4728f88300da4d5b6b9
Christian Brabandt <cb@256bit.org>
parents: 720
diff changeset
25 syn keyword sqlSpecial false null true
720
e180933b876a updated for version 7.0219
vimboss
parents:
diff changeset
26
7272
17333ebd2bbd commit https://github.com/vim/vim/commit/d042dc825c9b97dacd84d4728f88300da4d5b6b9
Christian Brabandt <cb@256bit.org>
parents: 720
diff changeset
27 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
28 syn keyword sqlKeyword cache compress connect current cursor decimal default desc
720
e180933b876a updated for version 7.0219
vimboss
parents:
diff changeset
29 syn keyword sqlKeyword else elsif end exception exclusive file for from
e180933b876a updated for version 7.0219
vimboss
parents:
diff changeset
30 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
31 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
32 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
33 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
34 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
35 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
36 syn keyword sqlKeyword where with option order pctfree pctused privileges procedure
720
e180933b876a updated for version 7.0219
vimboss
parents:
diff changeset
37 syn keyword sqlKeyword public resource return row rowlabel rownum rows
e180933b876a updated for version 7.0219
vimboss
parents:
diff changeset
38 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
39 syn keyword sqlKeyword join cross inner outer left right
720
e180933b876a updated for version 7.0219
vimboss
parents:
diff changeset
40
e180933b876a updated for version 7.0219
vimboss
parents:
diff changeset
41 syn keyword sqlOperator not and or
e180933b876a updated for version 7.0219
vimboss
parents:
diff changeset
42 syn keyword sqlOperator in any some all between exists
e180933b876a updated for version 7.0219
vimboss
parents:
diff changeset
43 syn keyword sqlOperator like escape
7272
17333ebd2bbd commit https://github.com/vim/vim/commit/d042dc825c9b97dacd84d4728f88300da4d5b6b9
Christian Brabandt <cb@256bit.org>
parents: 720
diff changeset
44 syn keyword sqlOperator union intersect minus
17333ebd2bbd commit https://github.com/vim/vim/commit/d042dc825c9b97dacd84d4728f88300da4d5b6b9
Christian Brabandt <cb@256bit.org>
parents: 720
diff changeset
45 syn keyword sqlOperator prior distinct
720
e180933b876a updated for version 7.0219
vimboss
parents:
diff changeset
46 syn keyword sqlOperator sysdate out
e180933b876a updated for version 7.0219
vimboss
parents:
diff changeset
47
7272
17333ebd2bbd commit https://github.com/vim/vim/commit/d042dc825c9b97dacd84d4728f88300da4d5b6b9
Christian Brabandt <cb@256bit.org>
parents: 720
diff changeset
48 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
49 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
50 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
51 syn keyword sqlStatement truncate
17333ebd2bbd commit https://github.com/vim/vim/commit/d042dc825c9b97dacd84d4728f88300da4d5b6b9
Christian Brabandt <cb@256bit.org>
parents: 720
diff changeset
52 " 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
53 syn keyword sqlStatement create update alter select insert contained
720
e180933b876a updated for version 7.0219
vimboss
parents:
diff changeset
54
14193
c460506890ba Update runtime files.
Christian Brabandt <cb@256bit.org>
parents: 13937
diff changeset
55 syn keyword sqlType bfile blob boolean char character clob date datetime
c460506890ba Update runtime files.
Christian Brabandt <cb@256bit.org>
parents: 13937
diff changeset
56 syn keyword sqlType dec decimal float int integer long mlslabel nchar
c460506890ba Update runtime files.
Christian Brabandt <cb@256bit.org>
parents: 13937
diff changeset
57 syn keyword sqlType nclob number numeric nvarchar2 precision raw rowid
c460506890ba Update runtime files.
Christian Brabandt <cb@256bit.org>
parents: 13937
diff changeset
58 syn keyword sqlType smallint real timestamp urowid varchar varchar2 varray
720
e180933b876a updated for version 7.0219
vimboss
parents:
diff changeset
59
7272
17333ebd2bbd commit https://github.com/vim/vim/commit/d042dc825c9b97dacd84d4728f88300da4d5b6b9
Christian Brabandt <cb@256bit.org>
parents: 720
diff changeset
60 " Strings:
14193
c460506890ba Update runtime files.
Christian Brabandt <cb@256bit.org>
parents: 13937
diff changeset
61 syn region sqlString matchgroup=Quote start=+n\?"+ end=+"+
c460506890ba Update runtime files.
Christian Brabandt <cb@256bit.org>
parents: 13937
diff changeset
62 syn region sqlString matchgroup=Quote start=+n\?'+ end=+'+
9644
9f7bcc2c3b97 commit https://github.com/vim/vim/commit/6f1d9a096bf22d50c727dca73abbfb8e3ff55176
Christian Brabandt <cb@256bit.org>
parents: 7272
diff changeset
63 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
64 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
65 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
66 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
67 syn region sqlString matchgroup=Quote start=+n\?q'\[+ end=+]'+
720
e180933b876a updated for version 7.0219
vimboss
parents:
diff changeset
68
e180933b876a updated for version 7.0219
vimboss
parents:
diff changeset
69 " Numbers:
7272
17333ebd2bbd commit https://github.com/vim/vim/commit/d042dc825c9b97dacd84d4728f88300da4d5b6b9
Christian Brabandt <cb@256bit.org>
parents: 720
diff changeset
70 syn match sqlNumber "-\=\<\d*\.\=[0-9_]\>"
720
e180933b876a updated for version 7.0219
vimboss
parents:
diff changeset
71
e180933b876a updated for version 7.0219
vimboss
parents:
diff changeset
72 " Comments:
7272
17333ebd2bbd commit https://github.com/vim/vim/commit/d042dc825c9b97dacd84d4728f88300da4d5b6b9
Christian Brabandt <cb@256bit.org>
parents: 720
diff changeset
73 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
74 syn match sqlComment "--.*$" contains=sqlTodo,@Spell
14193
c460506890ba Update runtime files.
Christian Brabandt <cb@256bit.org>
parents: 13937
diff changeset
75 syn match sqlComment "^rem.*$" contains=sqlTodo,@Spell
7272
17333ebd2bbd commit https://github.com/vim/vim/commit/d042dc825c9b97dacd84d4728f88300da4d5b6b9
Christian Brabandt <cb@256bit.org>
parents: 720
diff changeset
76
17333ebd2bbd commit https://github.com/vim/vim/commit/d042dc825c9b97dacd84d4728f88300da4d5b6b9
Christian Brabandt <cb@256bit.org>
parents: 720
diff changeset
77 " Setup Folding:
17333ebd2bbd commit https://github.com/vim/vim/commit/d042dc825c9b97dacd84d4728f88300da4d5b6b9
Christian Brabandt <cb@256bit.org>
parents: 720
diff changeset
78 " 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
79 " 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
80 " have contained option.
17333ebd2bbd commit https://github.com/vim/vim/commit/d042dc825c9b97dacd84d4728f88300da4d5b6b9
Christian Brabandt <cb@256bit.org>
parents: 720
diff changeset
81 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
82
e180933b876a updated for version 7.0219
vimboss
parents:
diff changeset
83 syn sync ccomment sqlComment
e180933b876a updated for version 7.0219
vimboss
parents:
diff changeset
84
7272
17333ebd2bbd commit https://github.com/vim/vim/commit/d042dc825c9b97dacd84d4728f88300da4d5b6b9
Christian Brabandt <cb@256bit.org>
parents: 720
diff changeset
85 " Functions:
17333ebd2bbd commit https://github.com/vim/vim/commit/d042dc825c9b97dacd84d4728f88300da4d5b6b9
Christian Brabandt <cb@256bit.org>
parents: 720
diff changeset
86 " (Oracle 11g)
17333ebd2bbd commit https://github.com/vim/vim/commit/d042dc825c9b97dacd84d4728f88300da4d5b6b9
Christian Brabandt <cb@256bit.org>
parents: 720
diff changeset
87 " Aggregate Functions
17333ebd2bbd commit https://github.com/vim/vim/commit/d042dc825c9b97dacd84d4728f88300da4d5b6b9
Christian Brabandt <cb@256bit.org>
parents: 720
diff changeset
88 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
89 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
90 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
91 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
92 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
93 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
94 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
95 " Char Functions
17333ebd2bbd commit https://github.com/vim/vim/commit/d042dc825c9b97dacd84d4728f88300da4d5b6b9
Christian Brabandt <cb@256bit.org>
parents: 720
diff changeset
96 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
97 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
98 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
99 " Comparison Functions
17333ebd2bbd commit https://github.com/vim/vim/commit/d042dc825c9b97dacd84d4728f88300da4d5b6b9
Christian Brabandt <cb@256bit.org>
parents: 720
diff changeset
100 syn keyword sqlFunction greatest least
17333ebd2bbd commit https://github.com/vim/vim/commit/d042dc825c9b97dacd84d4728f88300da4d5b6b9
Christian Brabandt <cb@256bit.org>
parents: 720
diff changeset
101 " Conversion Functions
17333ebd2bbd commit https://github.com/vim/vim/commit/d042dc825c9b97dacd84d4728f88300da4d5b6b9
Christian Brabandt <cb@256bit.org>
parents: 720
diff changeset
102 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
103 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
104 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
105 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
106 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
107 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
108 " DataMining Functions
17333ebd2bbd commit https://github.com/vim/vim/commit/d042dc825c9b97dacd84d4728f88300da4d5b6b9
Christian Brabandt <cb@256bit.org>
parents: 720
diff changeset
109 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
110 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
111 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
112 " Datetime Functions
17333ebd2bbd commit https://github.com/vim/vim/commit/d042dc825c9b97dacd84d4728f88300da4d5b6b9
Christian Brabandt <cb@256bit.org>
parents: 720
diff changeset
113 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
114 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
115 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
116 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
117 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
118 " Numeric Functions
17333ebd2bbd commit https://github.com/vim/vim/commit/d042dc825c9b97dacd84d4728f88300da4d5b6b9
Christian Brabandt <cb@256bit.org>
parents: 720
diff changeset
119 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
120 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
121 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
122 " NLS Functions
17333ebd2bbd commit https://github.com/vim/vim/commit/d042dc825c9b97dacd84d4728f88300da4d5b6b9
Christian Brabandt <cb@256bit.org>
parents: 720
diff changeset
123 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
124 " Various Functions
17333ebd2bbd commit https://github.com/vim/vim/commit/d042dc825c9b97dacd84d4728f88300da4d5b6b9
Christian Brabandt <cb@256bit.org>
parents: 720
diff changeset
125 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
126 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
127 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
128 " XML Functions
17333ebd2bbd commit https://github.com/vim/vim/commit/d042dc825c9b97dacd84d4728f88300da4d5b6b9
Christian Brabandt <cb@256bit.org>
parents: 720
diff changeset
129 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
130 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
131 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
132 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
133 " Todo:
17333ebd2bbd commit https://github.com/vim/vim/commit/d042dc825c9b97dacd84d4728f88300da4d5b6b9
Christian Brabandt <cb@256bit.org>
parents: 720
diff changeset
134 syn keyword sqlTodo TODO FIXME XXX DEBUG NOTE contained
720
e180933b876a updated for version 7.0219
vimboss
parents:
diff changeset
135
e180933b876a updated for version 7.0219
vimboss
parents:
diff changeset
136 " Define the default highlighting.
14193
c460506890ba Update runtime files.
Christian Brabandt <cb@256bit.org>
parents: 13937
diff changeset
137 hi def link Quote Special
c460506890ba Update runtime files.
Christian Brabandt <cb@256bit.org>
parents: 13937
diff changeset
138 hi def link sqlComment Comment
c460506890ba Update runtime files.
Christian Brabandt <cb@256bit.org>
parents: 13937
diff changeset
139 hi def link sqlFunction Function
c460506890ba Update runtime files.
Christian Brabandt <cb@256bit.org>
parents: 13937
diff changeset
140 hi def link sqlKeyword sqlSpecial
c460506890ba Update runtime files.
Christian Brabandt <cb@256bit.org>
parents: 13937
diff changeset
141 hi def link sqlNumber Number
c460506890ba Update runtime files.
Christian Brabandt <cb@256bit.org>
parents: 13937
diff changeset
142 hi def link sqlOperator sqlStatement
c460506890ba Update runtime files.
Christian Brabandt <cb@256bit.org>
parents: 13937
diff changeset
143 hi def link sqlSpecial Special
10051
46763b01cd9a commit https://github.com/vim/vim/commit/f37506f60f87d52a9e8850e30067645e2b13783c
Christian Brabandt <cb@256bit.org>
parents: 9644
diff changeset
144 hi def link sqlStatement Statement
14193
c460506890ba Update runtime files.
Christian Brabandt <cb@256bit.org>
parents: 13937
diff changeset
145 hi def link sqlString String
10051
46763b01cd9a commit https://github.com/vim/vim/commit/f37506f60f87d52a9e8850e30067645e2b13783c
Christian Brabandt <cb@256bit.org>
parents: 9644
diff changeset
146 hi def link sqlType Type
46763b01cd9a commit https://github.com/vim/vim/commit/f37506f60f87d52a9e8850e30067645e2b13783c
Christian Brabandt <cb@256bit.org>
parents: 9644
diff changeset
147 hi def link sqlTodo Todo
720
e180933b876a updated for version 7.0219
vimboss
parents:
diff changeset
148
e180933b876a updated for version 7.0219
vimboss
parents:
diff changeset
149 let b:current_syntax = "sql"
e180933b876a updated for version 7.0219
vimboss
parents:
diff changeset
150 " vim: ts=8