Variable: sql-mode-oracle-font-lock-keywords
sql-mode-oracle-font-lock-keywords is a variable defined in sql.el.gz.
Value
(("^rem\\(?:a\\|ar\\|ark\\)?\\(?:\\s-.*\\)?$" 0 font-lock-comment-face
t)
("^\\(?:\\<\\(?:[@]\\{1,2\\}\\|acc\\(?:e\\|ep\\|ept\\)?\\|a\\(?:p\\|pp\\|ppe\\|ppen\\|ppend\\)?\\|archive\\|attribute\\|bre\\(?:a\\|ak\\)?\\|bti\\(?:t\\|tl\\|tle\\)?\\|c\\(?:h\\|ha\\|han\\|hang\\|hange\\)?\\|cl\\(?:e\\|ea\\|ear\\)?\\|col\\(?:u\\|um\\|umn\\)?\\|conn\\(?:e\\|ec\\|ect\\)?\\|copy\\|def\\(?:i\\|in\\|ine\\)?\\|del\\|desc\\(?:r\\|ri\\|rib\\|ribe\\)?\\|disc\\(?:o\\|on\\|onn\\|onne\\|onnec\\|onnect\\)?\\|ed\\(?:i\\|it\\)?\\|exec\\(?:u\\|ut\\|ute\\)?\\|exit\\|get\\|help\\|ho\\(?:s\\|st\\)?\\|[$]\\|i\\(?:n\\|np\\|npu\\|nput\\)?\\|l\\(?:i\\|is\\|ist\\)?\\|passw\\(?:o\\|or\\|ord\\)?\\|pau\\(?:s\\|se\\)?\\|pri\\(?:n\\|nt\\)?\\|pro\\(?:m\\|mp\\|mpt\\)?\\|quit\\|recover\\|repf\\(?:o\\|oo\\|oot\\|oote\\|ooter\\)?\\|reph\\(?:e\\|ea\\|ead\\|eade\\|eader\\)?\\|r\\(?:u\\|un\\)?\\|sav\\(?:e\\)?\\|sho\\(?:w\\)?\\|shutdown\\|spo\\(?:o\\|ol\\)?\\|sta\\(?:r\\|rt\\)?\\|startup\\|store\\|tim\\(?:i\\|in\\|ing\\)?\\|tti\\(?:t\\|tl\\|tle\\)?\\|undef\\(?:i\\|in\\|ine\\)?\\|var\\(?:i\\|ia\\|iab\\|iabl\\|iable\\)?\\|whenever\\)\\>\\|\\(?:comp\\(?:u\\|ut\\|ute\\)?\\s-+\\<\\(?:avg\\|cou\\(?:n\\|nt\\)?\\|min\\(?:i\\|im\\|imu\\|imum\\)?\\|max\\(?:i\\|im\\|imu\\|imum\\)?\\|num\\(?:b\\|be\\|ber\\)?\\|sum\\|std\\|var\\(?:i\\|ia\\|ian\\|ianc\\|iance\\)?\\)\\>\\)\\|\\(?:set\\s-+\\<\\(?:appi\\(?:n\\|nf\\|nfo\\)?\\|array\\(?:s\\|si\\|siz\\|size\\)?\\|auto\\(?:c\\|co\\|com\\|comm\\|commi\\|commit\\)?\\|autop\\(?:r\\|ri\\|rin\\|rint\\)?\\|autorecovery\\|autot\\(?:r\\|ra\\|rac\\|race\\)?\\|blo\\(?:c\\|ck\\|ckt\\|ckte\\|ckter\\|ckterm\\|cktermi\\|cktermin\\|cktermina\\|ckterminat\\|ckterminato\\|ckterminator\\)?\\|cmds\\(?:e\\|ep\\)?\\|colsep\\|com\\(?:p\\|pa\\|pat\\|pati\\|patib\\|patibi\\|patibil\\|patibili\\|patibilit\\|patibility\\)?\\|con\\(?:c\\|ca\\|cat\\)?\\|copyc\\(?:o\\|om\\|omm\\|ommi\\|ommit\\)?\\|copytypecheck\\|def\\(?:i\\|in\\|ine\\)?\\|describe\\|echo\\|editf\\(?:i\\|il\\|ile\\)?\\|emb\\(?:e\\|ed\\|edd\\|edde\\|edded\\)?\\|esc\\(?:a\\|ap\\|ape\\)?\\|feed\\(?:b\\|ba\\|bac\\|back\\)?\\|flagger\\|flu\\(?:s\\|sh\\)?\\|hea\\(?:d\\|di\\|din\\|ding\\)?\\|heads\\(?:e\\|ep\\)?\\|instance\\|lin\\(?:e\\|es\\|esi\\|esiz\\|esize\\)?\\|lobof\\(?:f\\|fs\\|fse\\|fset\\)?\\|long\\|longc\\(?:h\\|hu\\|hun\\|hunk\\|hunks\\|hunksi\\|hunksiz\\|hunksize\\)?\\|mark\\(?:u\\|up\\)?\\|newp\\(?:a\\|ag\\|age\\)?\\|null\\|numf\\(?:o\\|or\\|orm\\|orma\\|ormat\\)?\\|num\\(?:w\\|wi\\|wid\\|widt\\|width\\)?\\|pages\\(?:i\\|iz\\|ize\\)?\\|pau\\(?:s\\|se\\)?\\|recsep\\|recsepchar\\|scan\\|serverout\\(?:p\\|pu\\|put\\)?\\|shift\\(?:i\\|in\\|ino\\|inou\\|inout\\)?\\|show\\(?:m\\|mo\\|mod\\|mode\\)?\\|sqlbl\\(?:a\\|an\\|ank\\|ankl\\|ankli\\|anklin\\|ankline\\|anklines\\)?\\|sqlc\\(?:a\\|as\\|ase\\)?\\|sqlco\\(?:n\\|nt\\|nti\\|ntin\\|ntinu\\|ntinue\\)?\\|sqln\\(?:u\\|um\\|umb\\|umbe\\|umber\\)?\\|sqlpluscompat\\(?:i\\|ib\\|ibi\\|ibil\\|ibili\\|ibilit\\|ibility\\)?\\|sqlpre\\(?:f\\|fi\\|fix\\)?\\|sqlp\\(?:r\\|ro\\|rom\\|romp\\|rompt\\)?\\|sqlt\\(?:e\\|er\\|erm\\|ermi\\|ermin\\|ermina\\|erminat\\|erminato\\|erminator\\)?\\|suf\\(?:f\\|fi\\|fix\\)?\\|tab\\|term\\(?:o\\|ou\\|out\\)?\\|ti\\(?:m\\|me\\)?\\|timi\\(?:n\\|ng\\)?\\|trim\\(?:o\\|ou\\|out\\)?\\|trims\\(?:p\\|po\\|poo\\|pool\\)?\\|und\\(?:e\\|er\\|erl\\|erli\\|erlin\\|erline\\)?\\|ver\\(?:i\\|if\\|ify\\)?\\|wra\\(?:p\\)?\\)\\>\\)\\)\\(?:\\s-.*\\)?\\(?:[-]\n.*\\)*$"
0 font-lock-doc-face t)
("&?&\\(?:\\sw\\|\\s_\\)+[.]?" 0 font-lock-preprocessor-face t)
("%\\(bulk_\\(?:exceptions\\|rowcount\\)\\|found\\|isopen\\|notfound\\|row\\(?:count\\|type\\)\\|type\\)\\b"
. font-lock-builtin-face)
("\\b\\(a\\(?:bs\\|cos\\|dd_months\\|ppendchildxml\\|s\\(?:cii\\(?:str\\)?\\|in\\)\\|tan2?\\|vg\\)\\|b\\(?:filename\\|i\\(?:n_to_num\\|tand\\)\\)\\|c\\(?:a\\(?:rdinality\\|st\\)\\|eil\\|h\\(?:artorowid\\|r\\)\\|luster_\\(?:id\\|probability\\|set\\)\\|o\\(?:alesce\\|llect\\|mpose\\|n\\(?:cat\\|nect_by_\\(?:is\\(?:cycle\\|leaf\\)\\|root\\)\\|vert\\)\\|rr\\(?:_[ks]\\)?\\|sh?\\|unt\\|var_\\(?:\\(?:po\\|sam\\)p\\)\\)\\|u\\(?:be_table\\|me_dist\\|rrent_\\(?:date\\|timestamp\\)\\)\\|v\\)\\|d\\(?:ataobj_to_partition\\|btimezone\\|e\\(?:co\\(?:\\(?:d\\|mpos\\)e\\)\\|letexml\\|nse_rank\\|pth\\|ref\\)\\|ump\\)\\|e\\(?:mpty_\\(?:[bc]lob\\)\\|x\\(?:istsnode\\|p\\|tract\\(?:value\\)?\\)\\)\\|f\\(?:eature_\\(?:id\\|set\\|value\\)\\|irst\\(?:_value\\)?\\|loor\\|rom_tz\\)\\|gr\\(?:eatest\\|oup\\(?:_id\\|ing\\(?:_id\\)?\\)\\)\\|hextoraw\\|i\\(?:n\\(?:itcap\\|s\\(?:ert\\(?:childxml\\(?:after\\|before\\)?\\|xml\\(?:after\\|before\\)\\)\\|tr[24bc]?\\)\\)\\|teration_number\\)\\|l\\(?:a\\(?:g\\|st\\(?:_\\(?:day\\|value\\)\\)?\\)\\|e\\(?:a\\(?:d\\|st\\)\\|ngth[24bc]?\\)\\|istagg\\|n\\(?:nvl\\)?\\|o\\(?:caltimestamp\\|g\\|wer\\)\\|pad\\|trim\\)\\|m\\(?:a\\(?:ke_ref\\|x\\)\\|edian\\|in\\|o\\(?:d\\|nths_between\\)\\)\\|n\\(?:anvl\\|chr\\|e\\(?:w_time\\|xt_day\\)\\|ls\\(?:_\\(?:charset_\\(?:decl_len\\|id\\|name\\)\\|initcap\\|\\(?:low\\|upp\\)er\\)\\|sort\\)\\|t\\(?:\\(?:h_valu\\|il\\)e\\)\\|u\\(?:llif\\|mto\\(?:\\(?:ds\\|ym\\)interval\\)\\)\\|vl2?\\)\\|ora_\\(?:dst_\\(?:affected\\|convert\\|error\\)\\|hash\\)\\|p\\(?:ath\\|ercent\\(?:_rank\\|ile_\\(?:cont\\|disc\\)\\)\\|ower\\(?:multiset\\(?:_by_cardinality\\)?\\)?\\|re\\(?:diction\\(?:_\\(?:bounds\\|cost\\|details\\|probability\\|set\\)\\)?\\|sent\\(?:\\(?:nn\\)?v\\)\\|vious\\)\\)\\|r\\(?:a\\(?:nk\\|tio_to_report\\|wto\\(?:n?hex\\)\\)\\|e\\(?:f\\(?:tohex\\)?\\|g\\(?:exp_\\(?:count\\|instr\\|like\\|replace\\|substr\\)\\|r_\\(?:avg[xy]\\|count\\|intercept\\|r2\\|s\\(?:lope\\|x[xy]\\|yy\\)\\)\\)\\|mainder\\|place\\)\\|o\\(?:und\\|w\\(?:\\(?:_numbe\\|idto\\(?:n?cha\\)\\)r\\)\\)\\|pad\\|trim\\)\\|s\\(?:cn_to_timestamp\\|e\\(?:ssiontimezone\\|t\\)\\|i\\(?:gn\\|nh?\\)\\|oundex\\|qrt\\|t\\(?:ats_\\(?:binomial_test\\|crosstab\\|f_test\\|ks_test\\|m\\(?:ode\\|w_test\\)\\|one_way_anova\\|t_test_\\(?:indepu?\\|one\\|paired\\)\\|wsr_test\\)\\|ddev\\(?:_\\(?:\\(?:po\\|sam\\)p\\)\\)?\\)\\|u\\(?:bstr[24bc]?\\|m\\)\\|ys\\(?:_\\(?:con\\(?:nect_by_path\\|text\\)\\|dburigen\\|extract_utc\\|guid\\|typeid\\|xml\\(?:agg\\|gen\\)\\)\\|date\\|timestamp\\)\\)\\|t\\(?:anh?\\|imestamp_to_scn\\|o_\\(?:b\\(?:inary_\\(?:double\\|float\\)\\|lob\\)\\|c\\(?:har\\|lob\\)\\|d\\(?:ate\\|sinterval\\)\\|lob\\|multi_byte\\|n\\(?:c\\(?:har\\|lob\\)\\|umber\\)\\|single_byte\\|timestamp\\(?:_tz\\)?\\|yminterval\\)\\|r\\(?:anslate\\|eat\\|im\\|unc\\)\\|z_offset\\)\\|u\\(?:id\\|nistr\\|p\\(?:datexml\\|per\\)\\|ser\\(?:env\\)?\\)\\|v\\(?:a\\(?:lue\\|r\\(?:_\\(?:\\(?:po\\|sam\\)p\\)\\|iance\\)\\)\\|size\\)\\|width_bucket\\|xml\\(?:agg\\|c\\(?:ast\\|data\\|o\\(?:lattval\\|\\(?:mmen\\|nca\\)t\\)\\)\\|diff\\|e\\(?:lement\\|xists\\)\\|forest\\|isvalid\\|p\\(?:a\\(?:rse\\|tch\\)\\|i\\)\\|query\\|root\\|se\\(?:\\(?:quenc\\|rializ\\)e\\)\\|t\\(?:able\\|ransform\\)\\)\\)\\b"
. font-lock-builtin-face)
("\\b\\(a\\(?:bort\\|c\\(?:c\\(?:ess\\(?:ed\\)?\\|ount\\)\\|tivate\\)\\|d\\(?:d\\|min\\|vise\\)\\|fter\\|g\\(?:ent\\|gregate\\)\\|l\\(?:l\\(?:o\\(?:cate\\|w\\)\\)?\\|ter\\|ways\\)\\|n\\(?:alyze\\|cillary\\|[dy]\\)\\|pply\\|r\\(?:chive\\(?:log\\)?\\|ray\\)\\|s\\(?:c\\|sociate\\)\\|ttributes?\\|u\\(?:dit\\|t\\(?:h\\(?:enticated\\|id\\|orization\\)\\|o\\(?:allocate\\|matic\\)?\\)\\)\\|vailability\\|[st]\\)\\|b\\(?:ackup\\|e\\(?:fore\\|gin\\|half\\|tween\\)\\|i\\(?:nding\\|tmap\\)\\|lock\\(?:size\\)?\\|o\\(?:dy\\|th\\)\\|u\\(?:ffer_pool\\|ild\\)\\|y\\)\\|c\\(?:a\\(?:che\\|ll\\|ncel\\|s\\(?:\\(?:cad\\)?e\\)\\|tegory\\)\\|ertificate\\|h\\(?:a\\(?:ined\\|nge\\)\\|eck\\(?:point\\)?\\|ild\\|unk\\)\\|l\\(?:ass\\|ear\\|o\\(?:[ns]e\\)\\|uster\\)\\|o\\(?:lumn\\(?:_value\\|s\\)?\\|m\\(?:m\\(?:ent\\|it\\(?:ted\\)?\\)\\|p\\(?:atibility\\|ile\\|lete\\|osite_limit\\|ress\\|ute\\)\\)\\|n\\(?:nect\\(?:_time\\)?\\|s\\(?:i\\(?:der\\|stent\\)\\|tr\\(?:aints?\\|uctor\\)\\)\\|t\\(?:e\\(?:nts\\|xt\\)\\|\\(?:inu\\|rolfil\\)e\\)\\)\\|rruption\\|st\\)\\|pu_per_\\(?:call\\|session\\)\\|r\\(?:eate\\|oss\\)\\|u\\(?:be\\|rr\\(?:ent\\|val\\)\\)\\|ycle\\)\\|d\\(?:a\\(?:ngling\\|ta\\(?:base\\|files?\\)?\\|y\\)\\|dl\\|e\\(?:allocate\\|bug\\|f\\(?:ault\\|err\\(?:able\\|ed\\)\\|iner\\)\\|l\\(?:ay\\|ete\\)\\|mand\\|sc\\|termin\\(?:es\\|istic\\)\\)\\|i\\(?:ctionary\\|mension\\|rectory\\|s\\(?:a\\(?:\\(?:bl\\|ssociat\\)e\\)\\|connect\\|t\\(?:in\\(?:ct\\|guished\\)\\|ributed\\)\\)\\)\\|ml\\|rop\\)\\|e\\(?:ach\\|l\\(?:ement\\|se\\)\\|n\\(?:able\\|d\\)\\|quals_path\\|s\\(?:\\(?:cap\\|timat\\)e\\)\\|x\\(?:c\\(?:ept\\(?:ions\\)?\\|hange\\|luding\\)\\|ists\\|p\\(?:ire\\|lain\\)\\|te\\(?:nt\\|rnal\\(?:ly\\)?\\)\\)\\)\\|f\\(?:a\\(?:iled_login_attempts\\|st\\)\\|i\\(?:le\\|n\\(?:al\\|ish\\)\\)\\|lush\\|or\\(?:ce\\|eign\\)?\\|r\\(?:e\\(?:e\\(?:lists?\\|pools\\)\\|sh\\)\\|om\\)\\|u\\(?:ll\\|nctions?\\)\\)\\|g\\(?:enerated\\|lobal\\(?:_name\\|ly\\)?\\|r\\(?:ant\\|oup\\(?:ing\\|s\\)?\\)\\|uard\\)\\|h\\(?:a\\(?:sh\\(?:keys\\)?\\|ving\\)\\|eap\\|ierarchy\\)\\|i\\(?:d\\(?:entifie[dr]\\|le_time\\)\\|mmediate\\|n\\(?:c\\(?:luding\\|rement\\)\\|d\\(?:ex\\(?:e[ds]\\|types?\\)?\\|icator\\)\\|it\\(?:ial\\(?:ized\\|ly\\)?\\|rans\\)\\|ner\\|s\\(?:ert\\|t\\(?:an\\(?:\\(?:c\\|tiabl\\)e\\)\\|ead\\)\\)\\|t\\(?:ersect\\|o\\)\\|validate\\)\\|solation\\|[dns]\\)\\|j\\(?:ava\\|oin\\)\\|k\\(?:e\\(?:ep\\|y\\)\\|ill\\)\\|l\\(?:anguage\\|e\\(?:ft\\|ss\\|vels?\\)\\|i\\(?:brary\\|ke[24c]?\\|mit\\|nk\\|st\\)\\|o\\(?:c\\(?:a\\(?:l\\|t\\(?:ion\\|or\\)\\)\\|k\\)\\|g\\(?:file\\|ging\\|ical\\(?:_reads_per_\\(?:call\\|session\\)\\)?\\)\\|[bg]\\)\\)\\|m\\(?:a\\(?:n\\(?:age\\(?:d\\|ment\\)\\|ual\\)\\|p\\(?:ping\\)?\\|ster\\|t\\(?:\\(?:ch\\|erializ\\)ed\\)\\|x\\(?:datafiles\\|extents\\|i\\(?:mize\\|nstances\\)\\|log\\(?:files\\|history\\|members\\)\\|size\\|trans\\|value\\)\\)\\|e\\(?:m\\(?:ber\\|ory\\)\\|rge\\)\\|i\\(?:grate\\|n\\(?:extents\\|im\\(?:ize\\|um\\)\\|us\\|value\\)\\)\\|o\\(?:d\\(?:e\\|ify\\)\\|n\\(?:itoring\\|th\\)\\|unt\\|ve\\(?:ment\\)?\\)\\)\\|n\\(?:a\\(?:med?\\|tural\\)\\|e\\(?:sted\\|ver\\|w\\|xt\\(?:val\\)?\\)\\|o\\(?:a\\(?:rchivelog\\|udit\\)\\|c\\(?:ache\\|o\\(?:mpress\\|py\\)\\|ycle\\)\\|delay\\|force\\|logging\\|m\\(?:a\\(?:pping\\|xvalue\\)\\|in\\(?:\\(?:imiz\\|valu\\)e\\)\\|onitoring\\)\\|ne\\|order\\|parallel\\|r\\(?:e\\(?:ly\\|setlogs\\|verse\\)\\|mal\\|owdependencies\\)\\|s\\(?:ort\\|witch\\)\\|t\\(?:hing\\|imeout\\)?\\|validate\\|wait\\)?\\|ulls?\\)\\|o\\(?:bject\\|ff\\(?:line\\)?\\|idindex\\|ld\\|nl\\(?:ine\\|y\\)\\|p\\(?:e\\(?:n\\|rator\\)\\|ti\\(?:mal\\|on\\)\\)\\|r\\(?:der\\|ganization\\)\\|ut\\(?:er\\|line\\)?\\|ver\\(?:flow\\|riding\\)?\\|[fnr]\\)\\|p\\(?:a\\(?:ckages?\\|r\\(?:a\\(?:llel\\(?:_enable\\)?\\|meters\\)\\|ent\\|titions?\\)\\|ssword\\(?:_\\(?:grace_time\\|l\\(?:\\(?:ife\\|ock\\)_time\\)\\|reuse_\\(?:max\\|time\\)\\|verify_function\\)\\)?\\)\\|ct\\(?:free\\|increase\\|threshold\\|used\\|version\\)\\|er\\(?:cent\\|formance\\|manent\\)\\|file\\|hysical\\|i\\(?:pelined\\|vot\\)\\|lan\\|ost_transaction\\|r\\(?:agma\\|e\\(?:built\\|serve\\)\\|i\\(?:mary\\|v\\(?:ate\\(?:_sga\\)?\\|ileges\\)\\)\\|o\\(?:cedure\\|file\\|tection\\)\\)\\|u\\(?:blic\\|rge\\)\\)\\|qu\\(?:ery\\|iesce\\|ota\\)\\|r\\(?:ange\\|e\\(?:ads?\\|build\\|c\\(?:o\\(?:rds_per_block\\|very?\\)\\|ycle\\)\\|duced\\|f\\(?:erenc\\(?:es\\|ing\\)\\|resh\\)?\\|gister\\|ject\\|l\\(?:ational\\|y\\)\\|name\\|s\\(?:et\\(?:logs\\)?\\|ize\\|o\\(?:lver?\\|urce\\)\\|trict\\(?:_references\\|ed\\)?\\|u\\(?:lt\\|m\\(?:\\(?:abl\\)?e\\)\\)\\)\\|t\\(?:ention\\|urn\\(?:ing\\)?\\)\\|\\(?:us\\|v\\(?:ers\\|ok\\)\\|writ\\)e\\)\\|ight\\|n\\(?:[dp]s\\)\\|o\\(?:l\\(?:es?\\|l\\(?:back\\|up\\)\\)\\|w\\(?:dependencies\\|num\\|s\\)?\\)\\)\\|s\\(?:a\\(?:mple\\|vepoint\\)\\|c\\(?:an\\|hema\\|n\\|ope\\)\\|e\\(?:gment\\|l\\(?:ect\\(?:ivity\\)?\\|f\\)\\|quence\\|rializable\\|ssion\\(?:s_per_user\\)?\\|t\\(?:\\(?:ting\\)?s\\)?\\)\\|h\\(?:ared\\(?:_pool\\)?\\|rink\\|utdown\\)\\|i\\(?:blings\\|d\\|\\(?:ngl\\|z\\)e\\)\\|kip\\|o\\(?:me\\|rt\\|urce\\)\\|p\\(?:ace\\|ecification\\|file\\|lit\\)\\|t\\(?:a\\(?:ndby\\|rt\\|t\\(?:ement_id\\|i\\(?:c\\|stics\\)\\)\\)\\|o\\(?:p\\|r\\(?:\\(?:ag\\)?e\\)\\)\\|ructure\\)\\|u\\(?:b\\(?:partitions?\\|stitutable\\)\\|ccessful\\|pplemental\\|spend\\)\\|witch\\(?:over\\)?\\|y\\(?:nonym\\|s\\(?:tem\\)?\\)\\)\\|t\\(?:able\\(?:s\\(?:pace\\)?\\)?\\|e\\(?:mp\\(?:file\\|late\\|orary\\)\\|st\\)\\|h\\(?:an\\|en\\|r\\(?:ead\\|ough\\)\\)\\|ime\\(?:_zone\\|out\\)\\|o\\|r\\(?:a\\(?:ce\\|nsaction\\)\\|iggers?\\|u\\(?:ncate\\|st\\)\\)\\|ypes?\\)\\|u\\(?:n\\(?:archived\\|d\\(?:er\\(?:_path\\)?\\|o\\)\\|i\\(?:form\\|on\\|que\\)\\|l\\(?:imited\\|ock\\)\\|pivot\\|quiesce\\|recoverable\\|til\\|us\\(?:able\\|ed\\)\\)\\|p\\(?:\\(?:dat\\|grad\\)e\\)\\|s\\(?:age\\|e\\|ing\\)\\)\\|v\\(?:a\\(?:l\\(?:idat\\(?:e\\|ion\\)\\|ues?\\)\\|r\\(?:iable\\|ray\\)\\)\\|ersion\\|iew\\)\\|w\\(?:ait\\|he\\(?:n\\(?:ever\\)?\\|re\\)\\|ith\\(?:out\\)?\\|n\\(?:[dp]s\\)\\|ork\\|rite\\)\\|xml\\(?:data\\|schema\\|type\\)\\)\\b"
. font-lock-keyword-face)
("\\b\\(b\\(?:file\\|inary_\\(?:double\\|float\\)\\|lob\\|yte\\)\\|c\\(?:har\\(?:byte\\)?\\|lob\\)\\|da\\(?:te\\|y\\)\\|float\\|interval\\|lo\\(?:cal\\|ng\\(?:raw\\)?\\)\\|m\\(?:inute\\|onth\\)\\|n\\(?:c\\(?:har\\|lob\\)\\|umber\\|varchar2\\)\\|r\\(?:aw\\|owid\\)\\|second\\|time\\(?:stamp\\)?\\|urowid\\|varchar2\\|with\\|year\\|zone\\)\\b"
. font-lock-type-face)
("\\b\\(count\\|delete\\|ex\\(?:ists\\|tend\\)\\|first\\|l\\(?:\\(?:as\\|imi\\)t\\)\\|next\\|prior\\|sql\\(?:code\\|errm\\)\\|trim\\)\\b"
. font-lock-builtin-face)
("\\b\\(a\\(?:l\\(?:l\\|ter\\)\\|n[dy]\\|sc\\|[st]\\)\\|b\\(?:e\\(?:\\(?:gi\\|twee\\)n\\)\\|y\\)\\|c\\(?:ase\\|heck\\|lusters?\\|o\\(?:l\\(?:auth\\|umns\\)\\|mpress\\|nnect\\)\\|r\\(?:ash\\|eate\\)\\|ursor\\)\\|d\\(?:e\\(?:clare\\|fault\\|sc\\)\\|istinct\\|rop\\)\\|e\\(?:lse\\|nd\\|xc\\(?:eption\\|lusive\\)\\)\\|f\\(?:alse\\|etch\\|or\\|rom\\|unction\\)\\|g\\(?:oto\\|r\\(?:ant\\|oup\\)\\)\\|having\\|i\\(?:dentified\\|n\\(?:dex\\(?:es\\)?\\|sert\\|t\\(?:ersect\\|o\\)\\)\\|[fns]\\)\\|l\\(?:ike\\|ock\\)\\|m\\(?:inus\\|ode\\)\\|n\\(?:o\\(?:compress\\|\\(?:wai\\)?t\\)\\|ull\\)\\|o\\(?:ption\\|rder\\|verlaps\\|[fnr]\\)\\|p\\(?:rocedure\\|ublic\\)\\|r\\(?:aise_application_error\\|e\\(?:\\(?:sourc\\|vok\\)e\\)\\)\\|s\\(?:elect\\|hare\\|ize\\|ql\\|tart\\|ubtype\\)\\|t\\(?:ab\\(?:auth\\|le\\)\\|hen\\|o\\|\\(?:ru\\|yp\\)e\\)\\|u\\(?:ni\\(?:on\\|que\\)\\|pdate\\)\\|v\\(?:alues\\|iews?\\)\\|w\\(?:he\\(?:n\\|re\\)\\|ith\\)\\)\\b"
. font-lock-keyword-face)
("\\b\\(a\\(?:dd\\|g\\(?:ent\\|gregate\\)\\|rray\\|ttribute\\|ut\\(?:hid\\|onomous_transaction\\)\\|vg\\)\\|b\\(?:file_base\\|inary\\|lo\\(?:b_base\\|ck\\)\\|o\\(?:dy\\|th\\|und\\)\\|ulk\\|yte\\)\\|c\\(?:a\\(?:ll\\(?:ing\\)?\\|scade\\)\\|har\\(?:_base\\|acter\\|set\\(?:form\\|id\\)?\\)?\\|lo\\(?:\\(?:b_ba\\)?se\\)\\|o\\(?:llect\\|m\\(?:m\\(?:ent\\|it\\(?:ted\\)?\\)\\|piled\\)\\|n\\(?:st\\(?:ant\\|ructor\\)\\|t\\(?:ext\\|inue\\)\\|vert\\)\\|unt\\)\\|u\\(?:rrent\\|stomdatum\\)\\)\\|d\\(?:a\\(?:ngling\\|t\\(?:e_base\\|[ae]\\)\\|y\\)\\|e\\(?:fine\\|lete\\|terministic\\)\\|ouble\\|uration\\)\\|e\\(?:l\\(?:ement\\|sif\\)\\|mpty\\|scape\\|x\\(?:cept\\(?:ion\\(?:_init\\|s\\)\\)?\\|ecute\\|i\\(?:sts\\|t\\)\\|ternal\\)\\)\\|f\\(?:i\\(?:nal\\|xed\\)\\|loat\\|or\\(?:all\\|ce\\)\\)\\|general\\|h\\(?:ash\\|eap\\|idden\\|our\\)\\|i\\(?:mmediate\\|n\\(?:cluding\\|dic\\(?:ator\\|es\\)\\|finite\\|line\\|stantiable\\|t\\(?:er\\(?:face\\|val\\)\\)?\\|validate\\)\\|solation\\)\\|java\\|l\\(?:a\\(?:\\(?:ngua\\|r\\)ge\\)\\|e\\(?:ading\\|ngth\\|vel\\)\\|i\\(?:brary\\|ke[24c]\\|mit\\(?:ed\\)?\\)\\|o\\(?:cal\\|ng\\|op\\)\\)\\|m\\(?:a\\(?:xlen\\|[px]\\)\\|e\\(?:mber\\|rge\\)\\|in\\(?:ute\\)?\\|o\\(?:d\\(?:ify\\)?\\|nth\\)\\|ultiset\\)\\|n\\(?:a\\(?:me\\|n\\|ti\\(?:onal\\|ve\\)\\)\\|char\\|ew\\|ocopy\\|umber_base\\)\\|o\\(?:bject\\|ci\\(?:coll\\|d\\(?:ate\\(?:time\\)?\\|uration\\)\\|interval\\|loblocator\\|number\\|r\\(?:aw\\|ef\\(?:cursor\\)?\\|owid\\)\\|string\\|type\\)\\|ld\\|nly\\|p\\(?:aque\\|e\\(?:n\\|rator\\)\\)\\|r\\(?:a\\(?:cle\\|data\\)\\|ganization\\|l\\(?:\\(?:an\\|var\\)y\\)\\)\\|thers\\|ut\\|verriding\\)\\|p\\(?:a\\(?:ckage\\|r\\(?:a\\(?:llel_enable\\|meters?\\)\\|ent\\|tition\\)\\|scal\\)\\|ipe\\(?:lined\\)?\\|r\\(?:agma\\|ecision\\|i\\(?:or\\|vate\\)\\)\\)\\|r\\(?:a\\(?:ise\\|nge\\|w\\)\\|e\\(?:ad\\|cord\\|ference\\|lies_on\\|mainder\\|name\\|s\\(?:trict_references\\|ult\\(?:_cache\\)?\\)\\|turn\\(?:ing\\)?\\|verse\\|[fm]\\)\\|o\\(?:llback\\|w\\)\\)\\|s\\(?:a\\(?:mple\\|ve\\(?:point\\)?\\)\\|b[124]\\|e\\(?:cond\\|gment\\|lf\\|parate\\|quence\\|rial\\(?:\\(?:iz\\|ly_reus\\)able\\)\\|t\\)\\|hort\\|ize_t\\|ome\\|parse\\|ql\\(?:code\\|data\\|\\(?:nam\\|stat\\)e\\)\\|t\\(?:a\\(?:ndard\\|tic\\)\\|ddev\\|ored\\|r\\(?:ing\\|uct\\)\\|yle\\)\\|u\\(?:b\\(?:multiset\\|partition\\|stitutable\\)\\|m\\)\\|ynonym\\)\\|t\\(?:do\\|he\\|ime\\(?:stamp\\|zone_\\(?:abbr\\|hour\\|minute\\|region\\)\\)?\\|r\\(?:a\\(?:iling\\|nsaction\\(?:al\\)?\\)\\|usted\\)\\)\\|u\\(?:b[124]\\|n\\(?:der\\|\\(?:sign\\|trust\\)ed\\)\\|s\\(?:e\\|ing\\)\\)\\|v\\(?:a\\(?:l\\(?:ist\\|ue\\)\\|r\\(?:ia\\(?:\\(?:bl\\|nc\\)e\\)\\|ray\\|ying\\)\\)\\|oid\\)\\|w\\(?:hile\\|ork\\|r\\(?:apped\\|ite\\)\\)\\|year\\|zone\\|[ac]\\)\\b"
. font-lock-keyword-face)
("\\b\\(\"\\(?:\\(?:BINARY LARGE OBJECT\\|CHAR\\(?: \\(?:LARGE OBJECT\\|VARYING\\)\\|ACTER \\(?:LARGE OBJECT\\|VARYING\\)\\)\\|DOUBLE PRECISION\\|INTERVAL \\(?:DAY TO SECOND\\|YEAR TO MONTH\\)\\|LONG RAW\\|N\\(?:ATIONAL CHAR\\(?:ACTER\\(?: LARGE OBJECT\\)?\\)?\\|C\\(?:HAR\\(?: LARGE OBJECT\\)?\\|LOB\\)\\|VARCHAR2\\)\\|TIME\\(?:\\(?: WITH\\|STAMP WITH\\(?: LOCAL\\)?\\) TIME ZONE\\)\\)\"\\)\\|b\\(?:file\\(?:_base\\)?\\|inary_\\(?:double\\|float\\|integer\\)\\|lob\\(?:_base\\)?\\|oolean\\)\\|c\\(?:har\\(?:_base\\|acter\\)?\\|lob\\(?:_base\\)?\\|ursor\\)\\|d\\(?:a\\(?:te\\|y\\)\\|ec\\(?:imal\\)?\\|sinterval_unconstrained\\)\\|float\\|int\\(?:e\\(?:ger\\|rval\\)\\)?\\|lo\\(?:cal\\|ng\\)\\|m\\(?:lslabel\\|onth\\)\\|n\\(?:aturaln?\\|char_cs\\|um\\(?:ber\\(?:_base\\)?\\|eric\\)\\)\\|p\\(?:ls_integer\\|ositiven?\\)\\|r\\(?:aw\\|e\\(?:al\\|f\\)\\|owid\\)\\|s\\(?:econd\\|i\\(?:gntype\\|mple_\\(?:double\\|float\\|integer\\)\\)\\|mallint\\|tring\\)\\|t\\(?:ime\\(?:_\\(?:\\(?:tz_\\)?unconstrained\\)\\|stamp\\(?:_\\(?:\\(?:l?tz_\\)?unconstrained\\)\\)?\\)?\\|o\\)\\|urowid\\|varchar2?\\|with\\|y\\(?:ear\\|minterval_unconstrained\\)\\|zone\\)\\b"
. font-lock-type-face)
("\\b\\(access_into_null\\|c\\(?:ase_not_found\\|ollection_is_null\\|ursor_already_open\\)\\|dup_val_on_index\\|invalid_\\(?:\\(?:curso\\|numbe\\)r\\)\\|login_denied\\|no\\(?:_data_\\(?:\\(?:foun\\|neede\\)d\\)\\|t_logged_on\\)\\|program_error\\|rowtype_mismatch\\|s\\(?:elf_is_null\\|torage_error\\|ubscript_\\(?:\\(?:beyond_coun\\|outside_limi\\)t\\)\\|ys_invalid_rowid\\)\\|t\\(?:imeout_on_resource\\|oo_many_rows\\)\\|value_error\\|zero_divide\\)\\b"
. font-lock-warning-face))
Documentation
Oracle SQL keywords used by font-lock.
This variable is used by sql-mode and sql-interactive-mode. The
regular expressions are created during compilation by calling the
function regexp-opt. Therefore, take a look at the source before
you define your own sql-mode-oracle-font-lock-keywords. You may want
to add functions and PL/SQL keywords.
Source Code
;; Defined in /usr/src/emacs/lisp/progmodes/sql.el.gz
(defvar sql-mode-oracle-font-lock-keywords
(eval-when-compile
(list
;; Oracle SQL*Plus Commands
;; Only recognized in they start in column 1 and the
;; abbreviation is followed by a space or the end of line.
(list (concat "^" (sql-regexp-abbrev "rem~ark") "\\(?:\\s-.*\\)?$")
0 'font-lock-comment-face t)
(list
(concat
"^\\(?:"
(sql-regexp-abbrev-list
"[@]\\{1,2\\}" "acc~ept" "a~ppend" "archive" "attribute"
"bre~ak" "bti~tle" "c~hange" "cl~ear" "col~umn" "conn~ect"
"copy" "def~ine" "del" "desc~ribe" "disc~onnect" "ed~it"
"exec~ute" "exit" "get" "help" "ho~st" "[$]" "i~nput" "l~ist"
"passw~ord" "pau~se" "pri~nt" "pro~mpt" "quit" "recover"
"repf~ooter" "reph~eader" "r~un" "sav~e" "sho~w" "shutdown"
"spo~ol" "sta~rt" "startup" "store" "tim~ing" "tti~tle"
"undef~ine" "var~iable" "whenever")
"\\|"
(concat "\\(?:"
(sql-regexp-abbrev "comp~ute")
"\\s-+"
(sql-regexp-abbrev-list
"avg" "cou~nt" "min~imum" "max~imum" "num~ber" "sum"
"std" "var~iance")
"\\)")
"\\|"
(concat "\\(?:set\\s-+"
(sql-regexp-abbrev-list
"appi~nfo" "array~size" "auto~commit" "autop~rint"
"autorecovery" "autot~race" "blo~ckterminator"
"cmds~ep" "colsep" "com~patibility" "con~cat"
"copyc~ommit" "copytypecheck" "def~ine" "describe"
"echo" "editf~ile" "emb~edded" "esc~ape" "feed~back"
"flagger" "flu~sh" "hea~ding" "heads~ep" "instance"
"lin~esize" "lobof~fset" "long" "longc~hunksize"
"mark~up" "newp~age" "null" "numf~ormat" "num~width"
"pages~ize" "pau~se" "recsep" "recsepchar"
"scan" "serverout~put" "shift~inout" "show~mode"
"sqlbl~anklines" "sqlc~ase" "sqlco~ntinue"
"sqln~umber" "sqlpluscompat~ibility" "sqlpre~fix"
"sqlp~rompt" "sqlt~erminator" "suf~fix" "tab"
"term~out" "ti~me" "timi~ng" "trim~out" "trims~pool"
"und~erline" "ver~ify" "wra~p")
"\\)")
"\\)\\(?:\\s-.*\\)?\\(?:[-]\n.*\\)*$")
0 'font-lock-doc-face t)
'("&?&\\(?:\\sw\\|\\s_\\)+[.]?" 0 font-lock-preprocessor-face t)
;; Oracle PL/SQL Attributes (Declare these first to match %TYPE correctly)
(sql-font-lock-keywords-builder 'font-lock-builtin-face '("%" . "\\b")
"bulk_exceptions" "bulk_rowcount" "found" "isopen" "notfound"
"rowcount" "rowtype" "type"
)
;; Oracle Functions
(sql-font-lock-keywords-builder 'font-lock-builtin-face nil
"abs" "acos" "add_months" "appendchildxml" "ascii" "asciistr" "asin"
"atan" "atan2" "avg" "bfilename" "bin_to_num" "bitand" "cardinality"
"cast" "ceil" "chartorowid" "chr" "cluster_id" "cluster_probability"
"cluster_set" "coalesce" "collect" "compose" "concat" "convert" "corr"
"connect_by_root" "connect_by_iscycle" "connect_by_isleaf"
"corr_k" "corr_s" "cos" "cosh" "count" "covar_pop" "covar_samp"
"cube_table" "cume_dist" "current_date" "current_timestamp" "cv"
"dataobj_to_partition" "dbtimezone" "decode" "decompose" "deletexml"
"dense_rank" "depth" "deref" "dump" "empty_blob" "empty_clob"
"existsnode" "exp" "extract" "extractvalue" "feature_id" "feature_set"
"feature_value" "first" "first_value" "floor" "from_tz" "greatest"
"grouping" "grouping_id" "group_id" "hextoraw" "initcap"
"insertchildxml" "insertchildxmlafter" "insertchildxmlbefore"
"insertxmlafter" "insertxmlbefore" "instr" "instr2" "instr4" "instrb"
"instrc" "iteration_number" "lag" "last" "last_day" "last_value"
"lead" "least" "length" "length2" "length4" "lengthb" "lengthc"
"listagg" "ln" "lnnvl" "localtimestamp" "log" "lower" "lpad" "ltrim"
"make_ref" "max" "median" "min" "mod" "months_between" "nanvl" "nchr"
"new_time" "next_day" "nlssort" "nls_charset_decl_len"
"nls_charset_id" "nls_charset_name" "nls_initcap" "nls_lower"
"nls_upper" "nth_value" "ntile" "nullif" "numtodsinterval"
"numtoyminterval" "nvl" "nvl2" "ora_dst_affected" "ora_dst_convert"
"ora_dst_error" "ora_hash" "path" "percentile_cont" "percentile_disc"
"percent_rank" "power" "powermultiset" "powermultiset_by_cardinality"
"prediction" "prediction_bounds" "prediction_cost"
"prediction_details" "prediction_probability" "prediction_set"
"presentnnv" "presentv" "previous" "rank" "ratio_to_report" "rawtohex"
"rawtonhex" "ref" "reftohex" "regexp_count" "regexp_instr" "regexp_like"
"regexp_replace" "regexp_substr" "regr_avgx" "regr_avgy" "regr_count"
"regr_intercept" "regr_r2" "regr_slope" "regr_sxx" "regr_sxy"
"regr_syy" "remainder" "replace" "round" "rowidtochar" "rowidtonchar"
"row_number" "rpad" "rtrim" "scn_to_timestamp" "sessiontimezone" "set"
"sign" "sin" "sinh" "soundex" "sqrt" "stats_binomial_test"
"stats_crosstab" "stats_f_test" "stats_ks_test" "stats_mode"
"stats_mw_test" "stats_one_way_anova" "stats_t_test_indep"
"stats_t_test_indepu" "stats_t_test_one" "stats_t_test_paired"
"stats_wsr_test" "stddev" "stddev_pop" "stddev_samp" "substr"
"substr2" "substr4" "substrb" "substrc" "sum" "sysdate" "systimestamp"
"sys_connect_by_path" "sys_context" "sys_dburigen" "sys_extract_utc"
"sys_guid" "sys_typeid" "sys_xmlagg" "sys_xmlgen" "tan" "tanh"
"timestamp_to_scn" "to_binary_double" "to_binary_float" "to_blob"
"to_char" "to_clob" "to_date" "to_dsinterval" "to_lob" "to_multi_byte"
"to_nchar" "to_nclob" "to_number" "to_single_byte" "to_timestamp"
"to_timestamp_tz" "to_yminterval" "translate" "treat" "trim" "trunc"
"tz_offset" "uid" "unistr" "updatexml" "upper" "user" "userenv"
"value" "variance" "var_pop" "var_samp" "vsize" "width_bucket"
"xmlagg" "xmlcast" "xmlcdata" "xmlcolattval" "xmlcomment" "xmlconcat"
"xmldiff" "xmlelement" "xmlexists" "xmlforest" "xmlisvalid" "xmlparse"
"xmlpatch" "xmlpi" "xmlquery" "xmlroot" "xmlsequence" "xmlserialize"
"xmltable" "xmltransform"
)
;; See the table V$RESERVED_WORDS
;; Oracle Keywords
(sql-font-lock-keywords-builder 'font-lock-keyword-face nil
"abort" "access" "accessed" "account" "activate" "add" "admin"
"advise" "after" "agent" "aggregate" "all" "allocate" "allow" "alter"
"always" "analyze" "ancillary" "and" "any" "apply" "archive"
"archivelog" "array" "as" "asc" "associate" "at" "attribute"
"attributes" "audit" "authenticated" "authid" "authorization" "auto"
"autoallocate" "automatic" "availability" "backup" "before" "begin"
"behalf" "between" "binding" "bitmap" "block" "blocksize" "body"
"both" "buffer_pool" "build" "by" "cache" "call" "cancel"
"cascade" "case" "category" "certificate" "chained" "change" "check"
"checkpoint" "child" "chunk" "class" "clear" "clone" "close" "cluster"
"column" "column_value" "columns" "comment" "commit" "committed"
"compatibility" "compile" "complete" "composite_limit" "compress"
"compute" "connect" "connect_time" "consider" "consistent"
"constraint" "constraints" "constructor" "contents" "context"
"continue" "controlfile" "corruption" "cost" "cpu_per_call"
"cpu_per_session" "create" "cross" "cube" "current" "currval" "cycle"
"dangling" "data" "database" "datafile" "datafiles" "day" "ddl"
"deallocate" "debug" "default" "deferrable" "deferred" "definer"
"delay" "delete" "demand" "desc" "determines" "deterministic"
"dictionary" "dimension" "directory" "disable" "disassociate"
"disconnect" "distinct" "distinguished" "distributed" "dml" "drop"
"each" "element" "else" "enable" "end" "equals_path" "escape"
"estimate" "except" "exceptions" "exchange" "excluding" "exists"
"expire" "explain" "extent" "external" "externally"
"failed_login_attempts" "fast" "file" "final" "finish" "flush" "for"
"force" "foreign" "freelist" "freelists" "freepools" "fresh" "from"
"full" "function" "functions" "generated" "global" "global_name"
"globally" "grant" "group" "grouping" "groups" "guard" "hash"
"hashkeys" "having" "heap" "hierarchy" "id" "identified" "identifier"
"idle_time" "immediate" "in" "including" "increment" "index" "indexed"
"indexes" "indextype" "indextypes" "indicator" "initial" "initialized"
"initially" "initrans" "inner" "insert" "instance" "instantiable"
"instead" "intersect" "into" "invalidate" "is" "isolation" "java"
"join" "keep" "key" "kill" "language" "left" "less" "level"
"levels" "library" "like" "like2" "like4" "likec" "limit" "link"
"list" "lob" "local" "location" "locator" "lock" "log" "logfile"
"logging" "logical" "logical_reads_per_call"
"logical_reads_per_session" "managed" "management" "manual" "map"
"mapping" "master" "matched" "materialized" "maxdatafiles"
"maxextents" "maximize" "maxinstances" "maxlogfiles" "maxloghistory"
"maxlogmembers" "maxsize" "maxtrans" "maxvalue" "member" "memory"
"merge" "migrate" "minextents" "minimize" "minimum" "minus" "minvalue"
"mode" "modify" "monitoring" "month" "mount" "move" "movement" "name"
"named" "natural" "nested" "never" "new" "next" "nextval" "no"
"noarchivelog" "noaudit" "nocache" "nocompress" "nocopy" "nocycle"
"nodelay" "noforce" "nologging" "nomapping" "nomaxvalue" "nominimize"
"nominvalue" "nomonitoring" "none" "noorder" "noparallel" "norely"
"noresetlogs" "noreverse" "normal" "norowdependencies" "nosort"
"noswitch" "not" "nothing" "notimeout" "novalidate" "nowait" "null"
"nulls" "object" "of" "off" "offline" "oidindex" "old" "on" "online"
"only" "open" "operator" "optimal" "option" "or" "order"
"organization" "out" "outer" "outline" "over" "overflow" "overriding"
"package" "packages" "parallel" "parallel_enable" "parameters"
"parent" "partition" "partitions" "password" "password_grace_time"
"password_life_time" "password_lock_time" "password_reuse_max"
"password_reuse_time" "password_verify_function" "pctfree"
"pctincrease" "pctthreshold" "pctused" "pctversion" "percent"
"performance" "permanent" "pfile" "physical" "pipelined" "pivot" "plan"
"post_transaction" "pragma" "prebuilt" "preserve" "primary" "private"
"private_sga" "privileges" "procedure" "profile" "protection" "public"
"purge" "query" "quiesce" "quota" "range" "read" "reads" "rebuild"
"records_per_block" "recover" "recovery" "recycle" "reduced" "ref"
"references" "referencing" "refresh" "register" "reject" "relational"
"rely" "rename" "reset" "resetlogs" "resize" "resolve" "resolver"
"resource" "restrict" "restrict_references" "restricted" "result"
"resumable" "resume" "retention" "return" "returning" "reuse"
"reverse" "revoke" "rewrite" "right" "rnds" "rnps" "role" "roles"
"rollback" "rollup" "row" "rowdependencies" "rownum" "rows" "sample"
"savepoint" "scan" "schema" "scn" "scope" "segment" "select"
"selectivity" "self" "sequence" "serializable" "session"
"sessions_per_user" "set" "sets" "settings" "shared" "shared_pool"
"shrink" "shutdown" "siblings" "sid" "single" "size" "skip" "some"
"sort" "source" "space" "specification" "spfile" "split" "standby"
"start" "statement_id" "static" "statistics" "stop" "storage" "store"
"structure" "subpartition" "subpartitions" "substitutable"
"successful" "supplemental" "suspend" "switch" "switchover" "synonym"
"sys" "system" "table" "tables" "tablespace" "tempfile" "template"
"temporary" "test" "than" "then" "thread" "through" "time_zone"
"timeout" "to" "trace" "transaction" "trigger" "triggers" "truncate"
"trust" "type" "types" "unarchived" "under" "under_path" "undo"
"uniform" "union" "unique" "unlimited" "unlock" "unpivot" "unquiesce"
"unrecoverable" "until" "unusable" "unused" "update" "upgrade" "usage"
"use" "using" "validate" "validation" "value" "values" "variable"
"varray" "version" "view" "wait" "when" "whenever" "where" "with"
"without" "wnds" "wnps" "work" "write" "xmldata" "xmlschema" "xmltype"
)
;; Oracle Data Types
(sql-font-lock-keywords-builder 'font-lock-type-face nil
"bfile" "binary_double" "binary_float" "blob" "byte" "char" "charbyte"
"clob" "date" "day" "float" "interval" "local" "long" "longraw"
"minute" "month" "nchar" "nclob" "number" "nvarchar2" "raw" "rowid" "second"
"time" "timestamp" "urowid" "varchar2" "with" "year" "zone"
)
;; Oracle PL/SQL Functions
(sql-font-lock-keywords-builder 'font-lock-builtin-face nil
"delete" "trim" "extend" "exists" "first" "last" "count" "limit"
"prior" "next" "sqlcode" "sqlerrm"
)
;; Oracle PL/SQL Reserved words
(sql-font-lock-keywords-builder 'font-lock-keyword-face nil
"all" "alter" "and" "any" "as" "asc" "at" "begin" "between" "by"
"case" "check" "clusters" "cluster" "colauth" "columns" "compress"
"connect" "crash" "create" "cursor" "declare" "default" "desc"
"distinct" "drop" "else" "end" "exception" "exclusive" "fetch" "for"
"from" "function" "goto" "grant" "group" "having" "identified" "if"
"in" "index" "indexes" "insert" "intersect" "into" "is" "like" "lock"
"minus" "mode" "nocompress" "not" "nowait" "null" "of" "on" "option"
"or" "order" "overlaps" "procedure" "public" "resource" "revoke"
"select" "share" "size" "sql" "start" "subtype" "tabauth" "table"
"then" "to" "type" "union" "unique" "update" "values" "view" "views"
"when" "where" "with"
"true" "false"
"raise_application_error"
)
;; Oracle PL/SQL Keywords
(sql-font-lock-keywords-builder 'font-lock-keyword-face nil
"a" "add" "agent" "aggregate" "array" "attribute" "authid" "avg"
"bfile_base" "binary" "blob_base" "block" "body" "both" "bound" "bulk"
"byte" "c" "call" "calling" "cascade" "char" "char_base" "character"
"charset" "charsetform" "charsetid" "clob_base" "close" "collect"
"comment" "commit" "committed" "compiled" "constant" "constructor"
"context" "continue" "convert" "count" "current" "customdatum"
"dangling" "data" "date" "date_base" "day" "define" "delete"
"deterministic" "double" "duration" "element" "elsif" "empty" "escape"
"except" "exceptions" "execute" "exists" "exit" "external" "final"
"fixed" "float" "forall" "force" "general" "hash" "heap" "hidden"
"hour" "immediate" "including" "indicator" "indices" "infinite"
"instantiable" "int" "interface" "interval" "invalidate" "isolation"
"java" "language" "large" "leading" "length" "level" "library" "like2"
"like4" "likec" "limit" "limited" "local" "long" "loop" "map" "max"
"maxlen" "member" "merge" "min" "minute" "mod" "modify" "month"
"multiset" "name" "nan" "national" "native" "nchar" "new" "nocopy"
"number_base" "object" "ocicoll" "ocidate" "ocidatetime" "ociduration"
"ociinterval" "ociloblocator" "ocinumber" "ociraw" "ociref"
"ocirefcursor" "ocirowid" "ocistring" "ocitype" "old" "only" "opaque"
"open" "operator" "oracle" "oradata" "organization" "orlany" "orlvary"
"others" "out" "overriding" "package" "parallel_enable" "parameter"
"parameters" "parent" "partition" "pascal" "pipe" "pipelined" "pragma"
"precision" "prior" "private" "raise" "range" "raw" "read" "record"
"ref" "reference" "relies_on" "rem" "remainder" "rename" "result"
"result_cache" "return" "returning" "reverse" "rollback" "row"
"sample" "save" "savepoint" "sb1" "sb2" "sb4" "second" "segment"
"self" "separate" "sequence" "serializable" "set" "short" "size_t"
"some" "sparse" "sqlcode" "sqldata" "sqlname" "sqlstate" "standard"
"static" "stddev" "stored" "string" "struct" "style" "submultiset"
"subpartition" "substitutable" "sum" "synonym" "tdo" "the" "time"
"timestamp" "timezone_abbr" "timezone_hour" "timezone_minute"
"timezone_region" "trailing" "transaction" "transactional" "trusted"
"ub1" "ub2" "ub4" "under" "unsigned" "untrusted" "use" "using"
"valist" "value" "variable" "variance" "varray" "varying" "void"
"while" "work" "wrapped" "write" "year" "zone"
;; Pragma
"autonomous_transaction" "exception_init" "inline"
"restrict_references" "serially_reusable"
)
;; Oracle PL/SQL Data Types
(sql-font-lock-keywords-builder 'font-lock-type-face nil
"\"BINARY LARGE OBJECT\"" "\"CHAR LARGE OBJECT\"" "\"CHAR VARYING\""
"\"CHARACTER LARGE OBJECT\"" "\"CHARACTER VARYING\""
"\"DOUBLE PRECISION\"" "\"INTERVAL DAY TO SECOND\""
"\"INTERVAL YEAR TO MONTH\"" "\"LONG RAW\"" "\"NATIONAL CHAR\""
"\"NATIONAL CHARACTER LARGE OBJECT\"" "\"NATIONAL CHARACTER\""
"\"NCHAR LARGE OBJECT\"" "\"NCHAR\"" "\"NCLOB\"" "\"NVARCHAR2\""
"\"TIME WITH TIME ZONE\"" "\"TIMESTAMP WITH LOCAL TIME ZONE\""
"\"TIMESTAMP WITH TIME ZONE\""
"bfile" "bfile_base" "binary_double" "binary_float" "binary_integer"
"blob" "blob_base" "boolean" "char" "character" "char_base" "clob"
"clob_base" "cursor" "date" "day" "dec" "decimal"
"dsinterval_unconstrained" "float" "int" "integer" "interval" "local"
"long" "mlslabel" "month" "natural" "naturaln" "nchar_cs" "number"
"number_base" "numeric" "pls_integer" "positive" "positiven" "raw"
"real" "ref" "rowid" "second" "signtype" "simple_double"
"simple_float" "simple_integer" "smallint" "string" "time" "timestamp"
"timestamp_ltz_unconstrained" "timestamp_tz_unconstrained"
"timestamp_unconstrained" "time_tz_unconstrained" "time_unconstrained"
"to" "urowid" "varchar" "varchar2" "with" "year"
"yminterval_unconstrained" "zone"
)
;; Oracle PL/SQL Exceptions
(sql-font-lock-keywords-builder 'font-lock-warning-face nil
"access_into_null" "case_not_found" "collection_is_null"
"cursor_already_open" "dup_val_on_index" "invalid_cursor"
"invalid_number" "login_denied" "no_data_found" "no_data_needed"
"not_logged_on" "program_error" "rowtype_mismatch" "self_is_null"
"storage_error" "subscript_beyond_count" "subscript_outside_limit"
"sys_invalid_rowid" "timeout_on_resource" "too_many_rows"
"value_error" "zero_divide"
)))
"Oracle SQL keywords used by font-lock.
This variable is used by `sql-mode' and `sql-interactive-mode'. The
regular expressions are created during compilation by calling the
function `regexp-opt'. Therefore, take a look at the source before
you define your own `sql-mode-oracle-font-lock-keywords'. You may want
to add functions and PL/SQL keywords.")