Mercurial > vim

annotate runtime/syntax/sqloracle.vim @ 30489:1e4d93103d01 v9.0.0580

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
patch 9.0.0580: no CI running for MacOS on M1 Commit: https://github.com/vim/vim/commit/1d61408af31667669edcbffc876e4eafdcacca96 Author: Philip H <47042125+pheiduck@users.noreply.github.com> Date: Sat Sep 24 19:32:11 2022 +0100 patch 9.0.0580: no CI running for MacOS on M1 Problem: No CI running for MacOS on M1. Solution: Add a cirrus CI task. (closes https://github.com/vim/vim/issues/11203)
author Bram Moolenaar <Bram@vim.org>
date Sat, 24 Sep 2022 20:45:03 +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