📄 coldfusion sql.txt
字号:
-- ------------------------------------------------------------------------
/L16"Cold_Fusion" Noquote HTML_LANG Line Comment = // Block Comment On = <!--- Block Comment Off = ---> Block Comment On Alt = /* Block Comment Off Alt = */ File Extensions = cfm htm html
/Delimiters = ~!@$%^&*()+=|\{}[];"'<> , .?
/Function String = "name=*">"
/Function String 1 = "%[A-Z _]*[~\s]+(*)"
/Function String 2 = "% ++^(^{FUNCTION^}^{PROCEDURE^} [A-Z _ 0-9 a-z]+*^)"
/Function String 3 = "% ++^(CURSOR [A-Z _ 0-9 a-z]+ ^)+IS"
/Function String 4 = "%[ ^t]++function^(*(*)^)"
/Function String 5 = "%[ ^t]++^(*^)=[ ^t]++function*(*)"
/Indent Strings = "THEN" "LOOP" "ELSE" "BEGIN" "IS" "EXCEPTION" "ELSIF"
/Unindent Strings = "END IF;" "END LOOP;" "END;" "ELSE" "ELSIF"
/Ignore Strings SOL = "<!---" "--->"
-- -----------------------------------------------------------------------
/C1"TagsKeyWordsOpers"
// / />
.htm .html .css
<a <a> </a> <abbr <abbr> </abbr> <above> <abstract> </abstract> <acronym
<acronym> </acronym> <activity> </activity> <actor> <actor </actor> <add> <add
</add> <addName </addName> <address> <address </address> <addressList>
</addressList> <addrLine> <addSpan <admin </admin> <affiliation> </affiliation>
<alt <altGrp </altGrp> <analytic> </analytic> <anchor <any> </any> <app> <app
</app> <apply <arc <argument> </argument> <array> <area </area <arg <att> <att
</att> <attDef> <attDef </attDef> <attlDecl> <attlDecl </attlDecl> <attList>
<attList </attList> <attName> </attName> <author> </author> <authority>
</authority> <availability> <availability </availability>
abstract
ABORT ACCEPT ACCESS ADD ALL ALTER AND ANY APPEND ARRAY ARRAYLEN AS ASC ASSERT
ASSIGN AT ATTRIBUTES AUDIT AUTHORIZATION AVG
<b> <b </b> <back> <back </back> <base <baseWsd <bdo> <bdo </bdo> <bgsound
<bibl> <bibl </bibl> <biblFull> </biblFull> <biblScope> <biblStruct> <biblStruct
</biblStruct> <bicond> </bicond> <big> <big </big> <birth> <birth </birth>
<birthDate> <birthPlace> <blink> <blink </blink> <bloc </bloc> <blockquote>
<blockquote </blockquote> <body> <body </body> <box> </box> <br <br> <br />
<broadcast> </broadcast> <boolean <button> <button </button> <byline> </byline>
break byte
BASE_TABLE BEGIN BETWEEN BINARY_INTEGER BODY BOOLEAN BY
<c> <c </c> <caesura> <calEvent> </calEvent> <camera> </camera> <caption>
<caption </caption> <case> <castGroup> <castGroup </castGroup> <castItem>
<castItem </castItem> <castList> </castList> <catDesc> </catDesc> <category
</category> <catRef <cb> <cb <cell> <cell </cell> <center> <center </center>
<certainty <cf> </cf> <channel </channel> <change> <change </change> <character>
<character </character> <characters> </characters> <children> <children
<children/> <cit> </cit> <cite> <cite </cite> <city> </city> <cl> <cl </cl>
<class> <class </class> <classCode <classDecl> </classDecl> <classDoc> <classDoc
</classDoc> <classes> <classes </classes> <closer> </closer>
<code> <code </code> <codedCharSet> <codedCharSet <col> <col </col> <colgroup
<colgroup> </colgroup> <colloc> <colloc </colloc> <comment>
</comment> <commentary </commentary> <cond>
</cond> <constitution </constitution> <contents/> <corr> <corr </corr>
<correction> </correction> <country> <country </country> <creation> </creation>
<creationDate> </creationDate>
case catch char class const continue
CASE CAST CDATA CHAR CHAR_BASE CHECK CHMOD CLOSE CLUSTER CLUSTERS COLAUTH COLUMN
COMMENT COMMIT COMPLEMENT COMPRESS CONNECT CONNECTED CONSTANT CONSTRAINT
CONTAINS COPY CP CRASH CREATE CURRENT CURRVAL CURSOR
<damage> <damage </damage> <dataDesc> </dataDesc> <dataType> <date> <date
</date> <dateline> </dateline> <dateRange </dateRange> <dateStruct> <dateStruct
</dateStruct> <day> <day </day> <dd> <dd </dd> <def> </def> <default>
<define-macro </define-macro> <define-script> </define-script> <define-style
<del <del> </del> <delSpan <derivation </derivation> <desc> <desc </desc>
<descrip> <descrip </descrip> <dfn> <dfn </dfn> <dft> <direction <display-group>
<display-group </display-group> <distance> <distance </distance> <distinct
</distinct> <distributor> </distributor> <div> <div </div> <div0> <div0 </div0>
<div1> <div1 </div1> <div2> <div2 </div2> <div3> <div3 </div3> <div4> <div4
</div4> <div5> <div5 </div5> <div6> <div6 </div6> <div7> <div7 </div7> <divGen
<dl> <dl </dl> <doc> </doc> <docAuthor> </docAuthor> <docDate> <docEdition>
</docEdition> <docImprint> </docImprint> <docTitle> </docTitle> <domain
</domain> <dt> <dt </dt>
default default: delete do double
DATABASE DATA_BASE DATE DBA DEALLOCATE DEBUGOFF DEBUGON DECLARE DECIMAL DEFAULT
DEFINITION DELAY DELETE DESC DIGITS DISPOSE DISTINCT DO DOCTYPE DROP
<earliesttime <edition> <edition </edition> <editionStmt> </editionStmt>
<editor> <editor </editor> <editorialDecl> <editorialDecl </editorialDecl>
<education> </education> <eg> </eg> <egwd> </egwd> <eLeaf <elemDecl> <elemDecl
</elemDecl> <em> <em </em> <embed <emph> <emph </emph> <encodingDesc>
</encodingDesc> <ent </ent> <entDoc> <entDoc </entDoc> <entitySet> <entitySet
<entName> <entName </entName> <entry> <entry </entry> <entryFree> </entryFree>
<epigraph> <epigraph </epigraph> <epilogue> </epilogue> <equipment> </equipment>
<equiv <eTree </eTree> <etym> </etym> <eval> </eval> <event <exceptions>
<exceptions </exceptions> <exemplum> <exemplum </exemplum> <expan </expan>
<extent> </extent> <external-graphic <extFigure
else extends
ELSE ELSIF ENABLE END ENDS ENTITY ENTRY EQ EQUAL EQV ESCAPE EXCEPTION
EXCEPTION_INIT EXCHANGE EXCLUSIVE EXISTS EXIT EXTERNAL
<f </f> <factuality </factuality> <fAlt> <fAlt </fAlt> <fDecl> <fDecl </fDecl>
<fDescr> </fDescr> <fieldset> <fieldset </fieldset> <fig> <figDesc> </figDesc>
<figure </figure> <file <fileDesc> </fileDesc> <files> <files </files>
<firstLang> </firstLang> <fLib </fLib> <font </font> <foreign> <foreign
</foreign> <foreName> <foreName </foreName> <forest> <forest </forest>
<forestGrp> </forestGrp> <form> <form </form> <formula <formula> </formula>
<frame <frameset </frameset> <front> </front> <fs> <fs </fs> <fsConstraints>
<fsConstraints </fsConstraints> <fsdDecl <fsDecl </fsDecl> <fsDescr> <fsLib
</fsLib> <funder> </funder> <fvLib </fvLib> <fw </fw>
false file final finally float for function
FAST FETCH FILE FOR FORCE FORM FROM FULL FUNCTION
<gap> <gap <gen> </gen> <genName> </genName> <geog> </geog> <geogName> <geogName
</geogName> </gfn> <gi> <gi </gi> <gloss> <gloss </gloss> <gram </gram>
<gramGrp> <gramGrp </gramGrp> <graph </graph> <group> </group>
goto
GENERIC GOTO GRANT GREATER GROUP GT GTE
<h> </h> <h1> <h1 </h1> <h2> <h2 </h2> <h3> <h3 </h3> <h4> <h4 </h4> <h5> <h5
</h5> <h6> <h6 </h6> <hand> <hand <handList> </handList> <handShift> <handShift
<head> <head </head> <headItem> <headItem </headItem> <headLabel> <headLabel
</headLabel> <hi> <hi </hi> <hom> <hom </hom> <home> </home> <horizontal-rule/>
<hour> <hour </hour> <hps </hps> <hr> <hr <hr/> <hsn> </hsn> <html> <html
</html> <hwd> </hwd> <hyph> </hyph> <hyphenation </hyphenation>
HASH HAVING HOST HTML
<i <i> </i> <id <idno> <idno </idno> <if> <iff> <iframe <iframe> </iframe> <ihs>
</ihs> <ilayer> </ilayer> <img <imprimatur> <imprint> </imprint> <index
<iNode <input <input> <ins <ins> </ins> <interaction <interp <interpGrp>
<interpGrp </interpGrp> <interpretation> <intervaltime <invoke </invoke>
<isindex> <item> <item </item> <itype> <itype </itype>
if implements import in instanceof int interface
IDENTIFIED IF IMMEDIATE IMP IN INCREMENT INDEX INDEXES INDICATOR INITIAL
INITRANS INSERT INTERFACE INTERSECT INTO IS
<join <joinGrp </joinGrp>
JavaScript
JOIN
<kbd> <kbd </kbd> <keywords> <keywords </keywords> <kinesic
KEY
<l> <l </l> <label> <label </label> <lacunaEnd> <lacunaStart> <lang> </lang>
<langKnown> </langKnown> <language> <language </language> <langUsage>
</langUsage> <latesttime <layer> <layer </layer> <lb> <lb <lbl> <lbl </lbl>
<leaf <legend> <legend </legend> <lem> <lem <lg> <lg </lg> <lg1> <lg1 </lg1>
<lg2> <lg2 </lg2> <lg3> <lg3 </lg3> <lg4> <lg4 </lg4> <lg5> <lg5 </lg5> <li> <li
</li> <line> <line-field </line-field> <link> <link </link> <linkGrp </linkGrp>
<list> <list </list> <listBibl> </listBibl> <listing> </listing> <list-item
</list-item> <locale> <locator <log <logtarget </logtarget>
long
LEVEL LESS LIBRARY LIKE LIMITED LINK LOCAL LOCK LOG LOGGING LONG LOOP LOOPS LT
LTE
<m> <m </m> <map </map> <marquee </marquee> <measure </measure> <meeting>
</meeting> <mentioned> <mentioned </mentioned> <meta <metDecl> <metDecl
</metDecl> <milestone <minus> <minus <minute> <minute </minute> <monogr>
</monogr> <month> <month </month> <mood> <move <msr <multicol> </multicol>
<mylink </mylink>
MANY MASTER MATCHES MAXEXTENTS MAXTRANS MEMBER MINEXTENTS MINUS MISLABEL MOD
MODE MODIFY MOVE MULTISET
<name> <name </name> <nameLink> </nameLink> <nbr <nextid <nobr> </nobr>
<noembed> </noembed> <noframes> <noframes </noframes> <nolayer> </nolayer>
<none> <normalization> <normalization </normalization> <noscript> <noscript
</noscript> <note> <note </note> <notesStmt> </notesStmt> <null> <num <num>
</num> <number <number> </number>
native new null
NEAR NEAR/N NEQ NESTED NET NEW NEXT NO NOAUDIT NOCOMPRESS NOLOGGING NOPARALLEL
NOT NOWAIT NUMBER_BASE
<object> <object </object> <occasion> <occasion </occasion> <occupation>
<occupation </occupation> <offset> </offset> <ofig> <ol> <ol </ol> <omit> <omit
</omit> <opener> </opener> <optgroup> <optgroup </optgroup> <option> <option
</option> <oRef> <oRef <org> </org> <orgDivn </orgDivn> <orgName </orgName>
<orgTitle </orgTitle> <orgType </orgType> <orig> <orig </orig> <ornament
</ornament> <orth> <orth </orth> <otherForm> <oVar> <oVar </oVar>
OBJECT OF OFFLINE ONLINE ONLY OPEN OPTION OR ORDER OUT
<p <p> </p> <page> <paragraph> <paragraph </paragraph> <para <param <parents>
<part> <part </part> <particDesc> </particDesc> <participant> <participant
</participant> <participantGrp> <particLinks> <particLinks </particLinks>
<pause> <pb> <pb <per> <performance> </performance> <persName> <persName
</persName> <person </person> <personGrp> </personGrp> <ph> </ph> <phr> <phr
</phr> <place> </place> <placeName> <placeName </placeName> <plus> <plus <pos>
</pos> <postBox> </postBox> <postCode> </postCode> <pr> </pr> <pre> <pre </pre>
<pReg> <preparedness <principal> </principal> <profileDesc> </profileDesc>
<projectDesc> </projectDesc> <prologue> </prologue> <pron> <pron </pron>
<property <ptr <publicationStmt> </publicationStmt> <publisher>
</publisher> <pubPlace> </pubPlace> <purgetime <purpose <purposes> </purposes>
<pVar
package private protected public
PACKAGE PARAGRAPH PARALLEL PARTITION PCTFREE PCTINCREASE PCTUSED PLS_INTEGER
POSITIVE POSITIVEN PRAGMA PRIMARY PRIOR PRIVATE PRIVILEGES PROCEDURE PRODUCT
PUBLIC
<q> <q </q> <query </query> <quotation </quotation> <quote> </quote>
<range> <rate <rdg> <rdg </rdg> <rdgGrp </rdgGrp> <re> <re </re> <recording
</recording> <recordingStmt> </recordingStmt> <recordset </recordset> <ref> <ref
</ref> <refsDecl> <refsDecl </refsDecl> <reg> <reg </reg> <region> <region
</region> <relation <relationship </relationship> <relPlace> </relPlace>
<remarks> <rendition </rendition> <residence> </residence> <resp> </resp>
<respons <respStmt> </respStmt> <restore
</restore> <revisionDesc> </revisionDesc> <role> <role </role> <roleDesc>
</roleDesc> <roleName> <roleName </roleName> <root> <root <root/> <row> <row
</row> <rs> <rs </rs> <rule> <rule </rule>
reset return
RAISE RANGE RAW READ REBUILD RECORD REF REFERENCES REFRESH RELEASE RENAME
REPLACE RESOURCE RESTRICT RETURN RETURNING REVERSE REVOKE ROLLBACK ROW ROWID
ROWLABEL ROWNUM ROWS RUN
<salute> </salute> <samp> <samp </samp> <samplingDecl> </samplingDecl> <schedule
</schedule> <script <script> </script> <scriptStmt </scriptStmt> <scroll
</scroll> <second> <second </second> <seg> <seg </seg> <seg1> <seg1 </seg1>
<segmentation> </segmentation> <select <select> </select> <select-elements>
</select-elements> <sense> <sense </sense> <sequence> </sequence> <series>
</series> <seriesStmt> </seriesStmt> <seriesTitle> </seriesTitle> <set> </set>
<setting> <setting </setting> <settingDesc> </settingDesc> <settle> <settle
</settle> <settlement </settlement> <shift> <shift <sic> <sic </sic> <signed>
<signed </signed> <small> <small </small> <soCalled> <soCalled </soCalled>
<socecStatus> <socecStatus <sound> <sound </sound> <sourceDesc> </sourceDesc>
<sp> <sp </sp> <space <spacer> <span> <span </span> <spanGrp </spanGrp>
<speaker> </speaker> <sponsor> </sponsor> <sqrt> <stage> <stage </stage> <state>
<state </state> <stdVals> </stdVals> <step <str> <str </str> <street> </street>
<stress> <string <string> </string> <strong> <strong </strong> <structure
</structure> <style> <style </style> <style-rule> </style-rule> <sub> <sub
</sub> <subc> </subc> <sup> <sup </sup> <superEntry> </superEntry> <supplied>
<supplied </supplied> <surName> <surName </surName> <syll> </syll> <sym <symbol
short static stylesheet super switch synchronized
Scripts Scripts/StyleSheet StyleSheet
SAVEPOINT SCAN SCHEMA SEGMENT SELECT SENTENCE SEPARATE SESSION SET SHARE
SNAPSHOT SORT SPACE SQL SOME SPLIT START STARTS STATEMENT STEM STORAGE SUBSTRING
SUBTYPE SUCCESSFUL SUM SYNONYM
<table> <table </table> <tag> </tag> <tagDoc> </tagDoc> <tagsDecl> </tagsDecl>
<tagUsage </tagUsage> <target-element </target-element> <target-element/>
<taxonomy </taxonomy> <tbody> <tbody </tbody> <td <td> </td> <tech> <tech
</tech> <tei.2> </tei.2> <teiCorpus.2> </teiCorpus.2> <teiFsd2> </teiFsd2>
<teiHeader> <teiHeader </teiHeader> <term> <term </term> <termEntry> <termEntry
</termEntry> <text> <text </text> <textClass> </textClass> <textDesc> <textDesc
</textDesc> <then> <tig </tig> <time> <time </time> <timeLine> <timeLine
</timeLine> <timeRange </timeRange> <timeStruct> <timeStruct </timeStruct>
<textarea
<textarea> </textarea> <tfoot> <tfoot </tfoot> <th <th> </th> <thead> <thead
</thead> <title <title> </title> <titlePage> <titlePage </titlePage> <titlePart>
<titlePart </titlePart> <titleStmt> <titleStmt </titleStmt> <title-style <tns
</tns> <tr> <tr </tr> <trailer> </trailer> <trans> <trans </trans> <tree </tree>
<triangle </triangle> <tsd> </tsd> <tt> <tt </tt>
text/css text/JavaScript this throw transient true try
Transitional//EN
TABAUTH TABLE TABLES TABLESPACE TASK TERMINATE THAN THEN TO TRIGGER TRUNCATE
TYPE
<ul> <ul </ul> <uncertain> <unclear> <unclear </unclear> <usg> <usg </usg>
UNION UNIQUE UNLIMITED UNRECOVERABLE UNUSABLE UPDATE UPLOAD USE USING
<val> </val> <valDesc> </valDesc> <valList> <valList </valList> <valRange>
</valRange> <vAlt> <vAlt </vAlt> <var> <var </var> <variantEncoding>
<variantEncoding </variantEncoding> <vDefault> </vDefault> <view> </view> <vocal
<vol> <vRange> </vRange>
var vbscript void
VBScript
VALIDATE VALUE VALUES VARIABLE VIEW VIEWS
<w> <w </w> <warning-para </warning-para> <wbr> <week> <week </week> <what>
<when <who> </who> <wit> <witDetail </witDetail> <witEnd> <witList> </witList>
<witness </witness> <witStart> <work> </work> <writing </writing>
<writingSystemDeclaration> <writingSystemDeclaration </writingSystemDeclaration>
while with
WHEN WHENEVER WHERE WHILE WILDCARD WITH WORD WORK WRITE
<xml> </xml> <xmp> </xmp> <xptr <xr> <xr </xr> <xref <xsl> </xsl>
xml
XOR
<year> <year </year>
YES YESNO
2>
<
>
** <tei </tei
** scripts
** Scripts
-//W3C//DTD
-- -----------------------------------------------------------------------
/C2"CF_Tags_SQLTypes"
.cfm
BFILE BLOB
CF_ CF_SQL CF_SQL_CHAR CF_SQL_DECIMAL CF_SQL_INTEGER CF_SQL_MONEY CF_SQL_VARCHAR
CFCATCH CHARACTER CLOB
<CF_CFOCREATEOBJECT> <CF_COOLIMAGE> <CF_DELETECACHEFILES> <CF_EMBEDFLASHMOVIE>
<CF_EMBEDFLASHMOVIECOMMAND> <CF_EXPOSEDATATOFLASH> <CF_GETDIRECTORYCONTENTS>
<CF_MERCHDISPLAY> <CF_PLACEORDER> <CF_PROCESSPAYMENT> <CF_QUERYSORT>
<CF_SENDORDERCONFIRMATION> <CF_SHOPPINGCART> <CF_STRIPWHITESPACES>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -