sql-92.bnf.html

来自「sql 92的 bnf范式」· HTML 代码 · 共 505 行 · 第 1/5 页

HTML
505
字号
</p><p><a name="identifier start"> &nbsp; </a><a href="#xref-identifier%20start"> &lt;identifier start&gt; </a>&nbsp;&nbsp;&nbsp;::=&nbsp;&nbsp;<font color="red"> !! See the Syntax rules </font></p><p><a name="identifier part"> &nbsp; </a><a href="#xref-identifier%20part"> &lt;identifier part&gt; </a>&nbsp;&nbsp;&nbsp;::=&nbsp;&nbsp; <a href="#identifier%20start">&lt;identifier start&gt;</a>  |  <a href="#digit">&lt;digit&gt;</a></p><p><a name="key word"> &nbsp; </a><a href="#xref-key%20word"> &lt;key word&gt; </a>&nbsp;&nbsp;&nbsp;::=&nbsp;&nbsp; <a href="#reserved%20word">&lt;reserved word&gt;</a>  |  <a href="#non-reserved%20word">&lt;non-reserved word&gt;</a></p><p><a name="reserved word"> &nbsp; </a><a href="#xref-reserved%20word"> &lt;reserved word&gt; </a>&nbsp;&nbsp;&nbsp;::=<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <a href="#xref-ABSOLUTE"> ABSOLUTE </a>  |  <a href="#xref-ACTION"> ACTION </a>  |  <a href="#xref-ADD"> ADD </a>  |  <a href="#xref-ALL"> ALL </a>  |  <a href="#xref-ALLOCATE"> ALLOCATE </a>  |  <a href="#xref-ALTER"> ALTER </a>  |  <a href="#xref-AND"> AND </a>  |  <a href="#xref-ANY"> ANY </a>  |  <a href="#xref-ARE"> ARE </a><br>&nbsp;&nbsp;&nbsp;&nbsp; |&nbsp;&nbsp;&nbsp;&nbsp; <a href="#xref-AS"> AS </a>  |  <a href="#xref-ASC"> ASC </a>  |  <a href="#xref-ASSERTION"> ASSERTION </a>  |  <a href="#xref-AT"> AT </a>  |  <a href="#xref-AUTHORIZATION"> AUTHORIZATION </a>  |  <a href="#xref-AVG"> AVG </a><br>&nbsp;&nbsp;&nbsp;&nbsp; |&nbsp;&nbsp;&nbsp;&nbsp; <a href="#xref-BEGIN"> BEGIN </a>  |  <a href="#xref-BETWEEN"> BETWEEN </a>  |  <a href="#xref-BIT"> BIT </a>  |  <a href="#xref-BIT_LENGTH"> BIT_LENGTH </a>  |  <a href="#xref-BOTH"> BOTH </a>  |  <a href="#xref-BY"> BY </a><br>&nbsp;&nbsp;&nbsp;&nbsp; |&nbsp;&nbsp;&nbsp;&nbsp; <a href="#xref-CASCADE"> CASCADE </a>  |  <a href="#xref-CASCADED"> CASCADED </a>  |  <a href="#xref-CASE"> CASE </a>  |  <a href="#xref-CAST"> CAST </a>  |  <a href="#xref-CATALOG"> CATALOG </a>  |  <a href="#xref-CHAR"> CHAR </a>  |  <a href="#xref-CHARACTER"> CHARACTER </a>  |  <a href="#xref-CHARACTER_LENGTH"> CHARACTER_LENGTH </a><br>&nbsp;&nbsp;&nbsp;&nbsp; |&nbsp;&nbsp;&nbsp;&nbsp; <a href="#xref-CHAR_LENGTH"> CHAR_LENGTH </a>  |  <a href="#xref-CHECK"> CHECK </a>  |  <a href="#xref-CLOSE"> CLOSE </a>  |  <a href="#xref-COALESCE"> COALESCE </a>  |  <a href="#xref-COLLATE"> COLLATE </a>  |  <a href="#xref-COLLATION"> COLLATION </a>  |  <a href="#xref-COLUMN"> COLUMN </a>  |  <a href="#xref-COMMIT"> COMMIT </a><br>&nbsp;&nbsp;&nbsp;&nbsp; |&nbsp;&nbsp;&nbsp;&nbsp; <a href="#xref-CONNECT"> CONNECT </a>  |  <a href="#xref-CONNECTION"> CONNECTION </a>  |  <a href="#xref-CONSTRAINT"> CONSTRAINT </a>  |  <a href="#xref-CONSTRAINTS"> CONSTRAINTS </a>  |  <a href="#xref-CONTINUE"> CONTINUE </a>  |  <a href="#xref-CONVERT"> CONVERT </a>  |  <a href="#xref-CORRESPONDING"> CORRESPONDING </a><br>&nbsp;&nbsp;&nbsp;&nbsp; |&nbsp;&nbsp;&nbsp;&nbsp; <a href="#xref-CREATE"> CREATE </a>  |  <a href="#xref-CROSS"> CROSS </a>  |  <a href="#xref-CURRENT"> CURRENT </a>  |  <a href="#xref-CURRENT_DATE"> CURRENT_DATE </a>  |  <a href="#xref-CURRENT_TIME"> CURRENT_TIME </a>  |  <a href="#xref-CURRENT_TIMESTAMP"> CURRENT_TIMESTAMP </a>  |  <a href="#xref-CURRENT_USER"> CURRENT_USER </a>  |  <a href="#xref-CURSOR"> CURSOR </a><br>&nbsp;&nbsp;&nbsp;&nbsp; |&nbsp;&nbsp;&nbsp;&nbsp; <a href="#xref-DATE"> DATE </a>  |  <a href="#xref-DAY"> DAY </a>  |  <a href="#xref-DEALLOCATE"> DEALLOCATE </a>  |  <a href="#xref-DEC"> DEC </a>  |  <a href="#xref-DECIMAL"> DECIMAL </a>  |  <a href="#xref-DECLARE"> DECLARE </a>  |  <a href="#xref-DEFAULT"> DEFAULT </a><br>&nbsp;&nbsp;&nbsp;&nbsp; |&nbsp;&nbsp;&nbsp;&nbsp; <a href="#xref-DEFERRABLE"> DEFERRABLE </a>  |  <a href="#xref-DEFERRED"> DEFERRED </a>  |  <a href="#xref-DELETE"> DELETE </a>  |  <a href="#xref-DESC"> DESC </a>  |  <a href="#xref-DESCRIBE"> DESCRIBE </a>  |  <a href="#xref-DESCRIPTOR"> DESCRIPTOR </a>  |  <a href="#xref-DIAGNOSTICS"> DIAGNOSTICS </a><br>&nbsp;&nbsp;&nbsp;&nbsp; |&nbsp;&nbsp;&nbsp;&nbsp; <a href="#xref-DISCONNECT"> DISCONNECT </a>  |  <a href="#xref-DISTINCT"> DISTINCT </a>  |  <a href="#xref-DOMAIN"> DOMAIN </a>  |  <a href="#xref-DOUBLE"> DOUBLE </a>  |  <a href="#xref-DROP"> DROP </a><br>&nbsp;&nbsp;&nbsp;&nbsp; |&nbsp;&nbsp;&nbsp;&nbsp; <a href="#xref-ELSE"> ELSE </a>  |  <a href="#xref-END"> END </a>  |  <a href="#xref-END"> END </a> -EXEC  |  <a href="#xref-ESCAPE"> ESCAPE </a>  |  <a href="#xref-EXCEPT"> EXCEPT </a>  |  <a href="#xref-EXCEPTION"> EXCEPTION </a>  |  <a href="#xref-EXEC"> EXEC </a>  |  <a href="#xref-EXECUTE"> EXECUTE </a>  |  <a href="#xref-EXISTS"> EXISTS </a>  |  <a href="#xref-EXTERNAL"> EXTERNAL </a>  |  <a href="#xref-EXTRACT"> EXTRACT </a><br>&nbsp;&nbsp;&nbsp;&nbsp; |&nbsp;&nbsp;&nbsp;&nbsp; <a href="#xref-FALSE"> FALSE </a>  |  <a href="#xref-FETCH"> FETCH </a>  |  <a href="#xref-FIRST"> FIRST </a>  |  <a href="#xref-FLOAT"> FLOAT </a>  |  <a href="#xref-FOR"> FOR </a>  |  <a href="#xref-FOREIGN"> FOREIGN </a>  |  <a href="#xref-FOUND"> FOUND </a>  |  <a href="#xref-FROM"> FROM </a>  |  <a href="#xref-FULL"> FULL </a><br>&nbsp;&nbsp;&nbsp;&nbsp; |&nbsp;&nbsp;&nbsp;&nbsp; <a href="#xref-GET"> GET </a>  |  <a href="#xref-GLOBAL"> GLOBAL </a>  |  <a href="#xref-GO"> GO </a>  |  <a href="#xref-GOTO"> GOTO </a>  |  <a href="#xref-GRANT"> GRANT </a>  |  <a href="#xref-GROUP"> GROUP </a><br>&nbsp;&nbsp;&nbsp;&nbsp; |&nbsp;&nbsp;&nbsp;&nbsp; <a href="#xref-HAVING"> HAVING </a>  |  <a href="#xref-HOUR"> HOUR </a><br>&nbsp;&nbsp;&nbsp;&nbsp; |&nbsp;&nbsp;&nbsp;&nbsp; <a href="#xref-IDENTITY"> IDENTITY </a>  |  <a href="#xref-IMMEDIATE"> IMMEDIATE </a>  |  <a href="#xref-IN"> IN </a>  |  <a href="#xref-INDICATOR"> INDICATOR </a>  |  <a href="#xref-INITIALLY"> INITIALLY </a>  |  <a href="#xref-INNER"> INNER </a>  |  <a href="#xref-INPUT"> INPUT </a>  |  <a href="#xref-INSENSITIVE"> INSENSITIVE </a><br>&nbsp;&nbsp;&nbsp;&nbsp; |&nbsp;&nbsp;&nbsp;&nbsp; <a href="#xref-INSERT"> INSERT </a>  |  <a href="#xref-INT"> INT </a>  |  <a href="#xref-INTEGER"> INTEGER </a>  |  <a href="#xref-INTERSECT"> INTERSECT </a>  |  <a href="#xref-INTERVAL"> INTERVAL </a>  |  <a href="#xref-INTO"> INTO </a>  |  <a href="#xref-IS"> IS </a>  |  <a href="#xref-ISOLATION"> ISOLATION </a><br>&nbsp;&nbsp;&nbsp;&nbsp; |&nbsp;&nbsp;&nbsp;&nbsp; <a href="#xref-JOIN"> JOIN </a><br>&nbsp;&nbsp;&nbsp;&nbsp; |&nbsp;&nbsp;&nbsp;&nbsp; <a href="#xref-KEY"> KEY </a><br>&nbsp;&nbsp;&nbsp;&nbsp; |&nbsp;&nbsp;&nbsp;&nbsp; <a href="#xref-LANGUAGE"> LANGUAGE </a>  |  <a href="#xref-LAST"> LAST </a>  |  <a href="#xref-LEADING"> LEADING </a>  |  <a href="#xref-LEFT"> LEFT </a>  |  <a href="#xref-LEVEL"> LEVEL </a>  |  <a href="#xref-LIKE"> LIKE </a>  |  <a href="#xref-LOCAL"> LOCAL </a>  |  <a href="#xref-LOWER"> LOWER </a><br>&nbsp;&nbsp;&nbsp;&nbsp; |&nbsp;&nbsp;&nbsp;&nbsp; <a href="#xref-MATCH"> MATCH </a>  |  <a href="#xref-MAX"> MAX </a>  |  <a href="#xref-MIN"> MIN </a>  |  <a href="#xref-MINUTE"> MINUTE </a>  |  <a href="#xref-MODULE"> MODULE </a>  |  <a href="#xref-MONTH"> MONTH </a><br>&nbsp;&nbsp;&nbsp;&nbsp; |&nbsp;&nbsp;&nbsp;&nbsp; <a href="#xref-NAMES"> NAMES </a>  |  <a href="#xref-NATIONAL"> NATIONAL </a>  |  <a href="#xref-NATURAL"> NATURAL </a>  |  <a href="#xref-NCHAR"> NCHAR </a>  |  <a href="#xref-NEXT"> NEXT </a>  |  <a href="#xref-NO"> NO </a>  |  <a href="#xref-NOT"> NOT </a>  |  <a href="#xref-NULL"> NULL </a>  |  <a href="#xref-NULLIF"> NULLIF </a>  |  <a href="#xref-NUMERIC"> NUMERIC </a><br>&nbsp;&nbsp;&nbsp;&nbsp; |&nbsp;&nbsp;&nbsp;&nbsp; <a href="#xref-OCTET_LENGTH"> OCTET_LENGTH </a>  |  <a href="#xref-OF"> OF </a>  |  <a href="#xref-ON"> ON </a>  |  <a href="#xref-ONLY"> ONLY </a>  |  <a href="#xref-OPEN"> OPEN </a>  |  <a href="#xref-OPTION"> OPTION </a>  |  <a href="#xref-OR"> OR </a>  |  <a href="#xref-ORDER"> ORDER </a>  |  <a href="#xref-OUTER"> OUTER </a>  |  <a href="#xref-OUTPUT"> OUTPUT </a>  |  <a href="#xref-OVERLAPS"> OVERLAPS </a><br>&nbsp;&nbsp;&nbsp;&nbsp; |&nbsp;&nbsp;&nbsp;&nbsp; <a href="#xref-PAD"> PAD </a>  |  <a href="#xref-PARTIAL"> PARTIAL </a>  |  <a href="#xref-POSITION"> POSITION </a>  |  <a href="#xref-PRECISION"> PRECISION </a>  |  <a href="#xref-PREPARE"> PREPARE </a>  |  <a href="#xref-PRESERVE"> PRESERVE </a>  |  <a href="#xref-PRIMARY"> PRIMARY </a>  |  <a href="#xref-PRIOR"> PRIOR </a>  |  <a href="#xref-PRIVILEGES"> PRIVILEGES </a>  |  <a href="#xref-PROCEDURE"> PROCEDURE </a>  |  <a href="#xref-PUBLIC"> PUBLIC </a><br>&nbsp;&nbsp;&nbsp;&nbsp; |&nbsp;&nbsp;&nbsp;&nbsp; <a href="#xref-READ"> READ </a>  |  <a href="#xref-REAL"> REAL </a>  |  <a href="#xref-REFERENCES"> REFERENCES </a>  |  <a href="#xref-RELATIVE"> RELATIVE </a>  |  <a href="#xref-RESTRICT"> RESTRICT </a>  |  <a href="#xref-REVOKE"> REVOKE </a>  |  <a href="#xref-RIGHT"> RIGHT </a>  |  <a href="#xref-ROLLBACK"> ROLLBACK </a>  |  <a href="#xref-ROWS"> ROWS </a><br>&nbsp;&nbsp;&nbsp;&nbsp; |&nbsp;&nbsp;&nbsp;&nbsp; <a href="#xref-SCHEMA"> SCHEMA </a>  |  <a href="#xref-SCROLL"> SCROLL </a>  |  <a href="#xref-SECOND"> SECOND </a>  |  <a href="#xref-SECTION"> SECTION </a>  |  <a href="#xref-SELECT"> SELECT </a>  |  <a href="#xref-SESSION"> SESSION </a>  |  <a href="#xref-SESSION_USER"> SESSION_USER </a>  |  <a href="#xref-SET"> SET </a><br>&nbsp;&nbsp;&nbsp;&nbsp; |&nbsp;&nbsp;&nbsp;&nbsp; <a href="#xref-SIZE"> SIZE </a>  |  <a href="#xref-SMALLINT"> SMALLINT </a>  |  <a href="#xref-SOME"> SOME </a>  |  <a href="#xref-SPACE"> SPACE </a>  |  <a href="#xref-SQL"> SQL </a>  |  <a href="#xref-SQLCODE"> SQLCODE </a>  |  <a href="#xref-SQLERROR"> SQLERROR </a>  |  <a href="#xref-SQLSTATE"> SQLSTATE </a>  |  <a href="#xref-SUBSTRING"> SUBSTRING </a>  |  <a href="#xref-SUM"> SUM </a>  |  <a href="#xref-SYSTEM_USER"> SYSTEM_USER </a><br>&nbsp;&nbsp;&nbsp;&nbsp; |&nbsp;&nbsp;&nbsp;&nbsp; <a href="#xref-TABLE"> TABLE </a>  |  <a href="#xref-TEMPORARY"> TEMPORARY </a>  |  <a href="#xref-THEN"> THEN </a>  |  <a href="#xref-TIME"> TIME </a>  |  <a href="#xref-TIMESTAMP"> TIMESTAMP </a>  |  <a href="#xref-TIMEZONE_HOUR"> TIMEZONE_HOUR </a>  |  <a href="#xref-TIMEZONE_MINUTE"> TIMEZONE_MINUTE </a><br>&nbsp;&nbsp;&nbsp;&nbsp; |&nbsp;&nbsp;&nbsp;&nbsp; <a href="#xref-TO"> TO </a>  |  <a href="#xref-TRAILING"> TRAILING </a>  |  <a href="#xref-TRANSACTION"> TRANSACTION </a>  |  <a href="#xref-TRANSLATE"> TRANSLATE </a>  |  <a href="#xref-TRANSLATION"> TRANSLATION </a>  |  <a href="#xref-TRIM"> TRIM </a>  |  <a href="#xref-TRUE"> TRUE </a><br>&nbsp;&nbsp;&nbsp;&nbsp; |&nbsp;&nbsp;&nbsp;&nbsp; <a href="#xref-UNION"> UNION </a>  |  <a href="#xref-UNIQUE"> UNIQUE </a>  |  <a href="#xref-UNKNOWN"> UNKNOWN </a>  |  <a href="#xref-UPDATE"> UPDATE </a>  |  <a href="#xref-UPPER"> UPPER </a>  |  <a href="#xref-USAGE"> USAGE </a>  |  <a href="#xref-USER"> USER </a>  |  <a href="#xref-USING"> USING </a><br>&nbsp;&nbsp;&nbsp;&nbsp; |&nbsp;&nbsp;&nbsp;&nbsp; <a href="#xref-VALUE"> VALUE </a>  |  <a href="#xref-VALUES"> VALUES </a>  |  <a href="#xref-VARCHAR"> VARCHAR </a>  |  <a href="#xref-VARYING"> VARYING </a>  |  <a href="#xref-VIEW"> VIEW </a><br>&nbsp;&nbsp;&nbsp;&nbsp; |&nbsp;&nbsp;&nbsp;&nbsp; <a href="#xref-WHEN"> WHEN </a>  |  <a href="#xref-WHENEVER"> WHENEVER </a>  |  <a href="#xref-WHERE"> WHERE </a>  |  <a href="#xref-WITH"> WITH </a>  |  <a href="#xref-WORK"> WORK </a>  |  <a href="#xref-WRITE"> WRITE </a><br>&nbsp;&nbsp;&nbsp;&nbsp; |&nbsp;&nbsp;&nbsp;&nbsp; <a href="#xref-YEAR"> YEAR </a><br>&nbsp;&nbsp;&nbsp;&nbsp; |&nbsp;&nbsp;&nbsp;&nbsp; <a href="#xref-ZONE"> ZONE </a></p><p><a name="non-reserved word"> &nbsp; </a><a href="#xref-non-reserved%20word"> &lt;non-reserved word&gt; </a>&nbsp;&nbsp;&nbsp;::=<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <a href="#xref-ADA"> ADA </a><br>&nbsp;&nbsp;&nbsp;&nbsp; |&nbsp;&nbsp;&nbsp;&nbsp; <a href="#xref-C"> C </a>  |  <a href="#xref-CATALOG_NAME"> CATALOG_NAME </a>  |  <a href="#xref-CHARACTER_SET_CATALOG"> CHARACTER_SET_CATALOG </a>  |  <a href="#xref-CHARACTER_SET_NAME"> CHARACTER_SET_NAME </a>  |  <a href="#xref-CHARACTER_SET_SCHEMA"> CHARACTER_SET_SCHEMA </a><br>&nbsp;&nbsp;&nbsp;&nbsp; |&nbsp;&nbsp;&nbsp;&nbsp; <a href="#xref-CLASS_ORIGIN"> CLASS_ORIGIN </a>  |  <a href="#xref-COBOL"> COBOL </a>  |  <a href="#xref-COLLATION_CATALOG"> COLLATION_CATALOG </a>  |  <a href="#xref-COLLATION_NAME"> COLLATION_NAME </a>  |  <a href="#xref-COLLATION_SCHEMA"> COLLATION_SCHEMA </a><br>&nbsp;&nbsp;&nbsp;&nbsp; |&nbsp;&nbsp;&nbsp;&nbsp; <a href="#xref-COLUMN_NAME"> COLUMN_NAME </a>  |  <a href="#xref-COMMAND_FUNCTION"> COMMAND_FUNCTION </a>  |  <a href="#xref-COMMITTED"> COMMITTED </a>  |  <a href="#xref-CONDITION_NUMBER"> CONDITION_NUMBER </a>  |  <a href="#xref-CONNECTION_NAME"> CONNECTION_NAME </a><br>&nbsp;&nbsp;&nbsp;&nbsp; |&nbsp;&nbsp;&nbsp;&nbsp; <a href="#xref-CONSTRAINT_CATALOG"> CONSTRAINT_CATALOG </a>  |  <a href="#xref-CONSTRAINT_NAME"> CONSTRAINT_NAME </a>  |  <a href="#xref-CONSTRAINT_SCHEMA"> CONSTRAINT_SCHEMA </a>  |  <a href="#xref-CURSOR_NAME"> CURSOR_NAME </a><br>&nbsp;&nbsp;&nbsp;&nbsp; |&nbsp;&nbsp;&nbsp;&nbsp; <a href="#xref-DATA"> DATA </a>  |  <a href="#xref-DATETIME_INTERVAL_CODE"> DATETIME_INTERVAL_CODE </a>  |  <a href="#xref-DATETIME_INTERVAL_PRECISION"> DATETIME_INTERVAL_PRECISION </a>  |  <a href="#xref-DYNAMIC_FUNCTION"> DYNAMIC_FUNCTION </a><br>&nbsp;&nbsp;&nbsp;&nbsp; |&nbsp;&nbsp;&nbsp;&nbsp; <a href="#xref-FORTRAN"> FORTRAN </a><br>&nbsp;&nbsp;&nbsp;&nbsp; |&nbsp;&nbsp;&nbsp;&nbsp; <a href="#xref-LENGTH"> LENGTH </a><br>&nbsp;&nbsp;&nbsp;&nbsp; |&nbsp;&nbsp;&nbsp;&nbsp; <a href="#xref-MESSAGE_LENGTH"> MESSAGE_LENGTH </a>  |  <a href="#xref-MESSAGE_OCTET_LENGTH"> MESSAGE_OCTET_LENGTH </a>  |  <a href="#xref-MESSAGE_TEXT"> MESSAGE_TEXT </a>  |  <a href="#xref-MORE"> MORE </a>  |  <a href="#xref-MUMPS"> MUMPS </a><br>&nbsp;&nbsp;&nbsp;&nbsp; |&nbsp;&nbsp;&nbsp;&nbsp; <a href="#xref-NAME"> NAME </a>  |  <a href="#xref-NULLABLE"> NULLABLE </a>  |  <a href="#xref-NUMBER"> NUMBER </a><br>&nbsp;&nbsp;&nbsp;&nbsp; |&nbsp;&nbsp;&nbsp;&nbsp; <a href="#xref-PASCAL"> PASCAL </a>  |  <a href="#xref-PLI"> PLI </a><br>&nbsp;&nbsp;&nbsp;&nbsp; |&nbsp;&nbsp;&nbsp;&nbsp; <a href="#xref-REPEATABLE"> REPEATABLE </a>  |  <a href="#xref-RETURNED_LENGTH"> RETURNED_LENGTH </a>  |  <a href="#xref-RETURNED_OCTET_LENGTH"> RETURNED_OCTET_LENGTH </a>  |  <a href="#xref-RETURNED_SQLSTATE"> RETURNED_SQLSTATE </a>  |  <a href="#xref-ROW_COUNT"> ROW_COUNT </a><br>&nbsp;&nbsp;&nbsp;&nbsp; |&nbsp;&nbsp;&nbsp;&nbsp; <a href="#xref-SCALE"> SCALE </a>  |  <a href="#xref-SCHEMA_NAME"> SCHEMA_NAME </a>  |  <a href="#xref-SERIALIZABLE"> SERIALIZABLE </a>  |  <a href="#xref-SERVER_NAME"> SERVER_NAME </a>  |  <a href="#xref-SUBCLASS_ORIGIN"> SUBCLASS_ORIGIN </a><br>&nbsp;&nbsp;&nbsp;&nbsp; |&nbsp;&nbsp;&nbsp;&nbsp; <a href="#xref-TABLE_NAME"> TABLE_NAME </a>  |  <a href="#xref-TYPE"> TYPE </a><br>&nbsp;&nbsp;&nbsp;&nbsp; |&nbsp;&nbsp;&nbsp;&nbsp; <a href="#xref-UNCOMMITTED"> UNCOMMITTED </a>  |  <a href="#xref-UNNAMED"> UNNAMED </a></p><p><a href="#top">Top</a></p><hr><h2> Literal Numbers, Strings, Dates and Times</h2><p><a name="unsigned numeric literal"> &nbsp; </a><a href="#xref-unsigned%20numeric%20literal"> &lt;unsigned numeric literal&gt; </a>&nbsp;&nbsp;&nbsp;::=<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <a href="#exact%20numeric%20literal">&lt;exact numeric literal&gt;</a><br>&nbsp;&nbsp;&nbsp;&nbsp; |&nbsp;&nbsp;&nbsp;&nbsp; <a href="#approximate%20numeric%20literal">&lt;approximate numeric literal&gt;</a></p><p><a name="exact numeric literal"> &nbsp; </a><a href="#xref-exact%20numeric%20literal"> &lt;exact numeric literal&gt; </a>&nbsp;&nbsp;&nbsp;::=<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <a href="#unsigned%20integer">&lt;unsigned integer&gt;</a>  [  <a href="#period">&lt;period&gt;</a>  [  <a href="#unsigned%20integer">&lt;unsigned integer&gt;</a>  ]  ]<br>&nbsp;&nbsp;&nbsp;&nbsp; |&nbsp;&nbsp;&nbsp;&nbsp; <a href="#period">&lt;period&gt;</a>  <a href="#unsigned%20integer">&lt;unsigned integer&gt;</a></p><p><a name="unsigned integer"> &nbsp; </a><a href="#xref-unsigned%20integer"> &lt;unsigned integer&gt; </a>&nbsp;&nbsp;&nbsp;::=&nbsp;&nbsp; <a href="#digit">&lt;digit&gt;</a>  ...</p><p><a name="approximate numeric literal"> &nbsp; </a><a href="#xref-approximate%20numeric%20literal"> &lt;approximate numeric literal&gt; </a>&nbsp;&nbsp;&nbsp;::=<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <a href="#mantissa">&lt;mantissa&gt;</a>  <a href="#xref-E"> E </a>  <a href="#exponent">&lt;exponent&gt;</a></p><p><a name="mantissa"> &nbsp; </a><a href="#xref-mantissa"> &lt;mantissa&gt; </a>&nbsp;&nbsp;&nbsp;::=&nbsp;&nbsp; <a href="#exact%20numeric%20literal">&lt;exact numeric literal&gt;</a></p><p><a name="exponent"> &nbsp; </a><a href="#xref-exponent"> &lt;exponent&gt; </a>&nbsp;&nbsp;&nbsp;::=&nbsp;&nbsp; <a href="#signed%20integer">&lt;signed integer&gt;</a></p><p><a name="signed integer"> &nbsp; </a><a href="#xref-signed%20integer"> &lt;signed integer&gt; </a>&nbsp;&nbsp;&nbsp;::=&nbsp;&nbsp; [  <a href="#sign">&lt;sign&gt;</a>  ]  <a href="#unsigned%20integer">&lt;unsigned integer&gt;</a></p><p><a name="sign"> &nbsp; </a><a href="#xref-sign"> &lt;sign&gt; </a>&nbsp;&nbsp;&nbsp;::=&nbsp;&nbsp; <a href="#plus%20sign">&lt;plus sign&gt;</a>  |  <a href="#minus%20sign">&lt;minus sign&gt;</a></p><p><a name="national character string literal"> &nbsp; </a><a href="#xref-national%20character%20string%20literal"> &lt;national character string literal&gt; </a>&nbsp;&nbsp;&nbsp;::=<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <a href="#xref-N"> N </a>  <a href="#quote">&lt;quote&gt;</a>  [  <a href="#character%20representation">&lt;character representation&gt;</a>  ...  ]  <a href="#quote">&lt;quote&gt;</a>  [  {  <a href="#separator">&lt;separator&gt;</a> ...  <a href="#quote">&lt;quote&gt;</a>  [  <a href="#character%20representation">&lt;character representation&gt;</a> ...  ]  <a href="#quote">&lt;quote&gt;</a>  }...  ]</p><p><a name="character representation"> &nbsp; </a><a href="#xref-character%20representation"> &lt;character representation&gt; </a>&nbsp;&nbsp;&nbsp;::=&nbsp;&nbsp; <a href="#nonquote%20character">&lt;nonquote character&gt;</a>  |  <a href="#quote%20symbol">&lt;quote symbol&gt;</a></p><p><a name="nonquote character"> &nbsp; </a><a href="#xref-nonquote%20character"> &lt;nonquote character&gt; </a>&nbsp;&nbsp;&nbsp;::=&nbsp;&nbsp;<font color="red"> !! See the Syntax rules </font></p><p><a name="quote symbol"> &nbsp; </a><a href="#xref-quote%20symbol"> &lt;quote symbol&gt; </a>&nbsp;&nbsp;&nbsp;::=&nbsp;&nbsp; <a href="#quote">&lt;quote&gt;</a>  <a href="#quote">&lt;quote&gt;</a></p><p><a name="separator"> &nbsp; </a><a href="#xref-separator"> &lt;separator&gt; </a>&nbsp;&nbsp;&nbsp;::=&nbsp;&nbsp; {  <a href="#comment">&lt;comment&gt;</a>  |  <a href="#space">&lt;space&gt;</a>  |  <a href="#newline">&lt;newline&gt;</a>  }...</p><p><a name="comment"> &nbsp; </a><a href="#xref-comment"> &lt;comment&gt; </a>&nbsp;&nbsp;&nbsp;::=&nbsp;&nbsp; <a href="#comment%20introducer">&lt;comment introducer&gt;</a>  [  <a href="#comment%20character">&lt;comment character&gt;</a> ...  ]  <a href="#newline">&lt;newline&gt;</a></p><p><a name="comment introducer"> &nbsp; </a><a href="#xref-comment%20introducer"> &lt;comment introducer&gt; </a>&nbsp;&nbsp;&nbsp;::=&nbsp;&nbsp; <a href="#minus%20sign">&lt;minus sign&gt;</a> <a href="#minus%20sign">&lt;minus sign&gt;</a>  [&lt;minus  <a href="#xref-sign"> sign </a> &gt;...]</p><p><a name="comment character"> &nbsp; </a><a href="#xref-comment%20character"> &lt;comment character&gt; </a>&nbsp;&nbsp;&nbsp;::=&nbsp;&nbsp; <a href="#nonquote%20character">&lt;nonquote character&gt;</a>  |  <a href="#quote">&lt;quote&gt;</a></p><p><a name="newline"> &nbsp; </a><a href="#xref-newline"> &lt;newline&gt; </a>&nbsp;&nbsp;&nbsp;::=&nbsp;&nbsp;<font color="red"> !! implementation defined end of line indicator </font></p><p><a name="bit string literal"> &nbsp; </a><a href="#xref-bit%20string%20literal"> &lt;bit string literal&gt; </a>&nbsp;&nbsp;&nbsp;::=<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <a href="#xref-B"> B </a>  <a href="#quote">&lt;quote&gt;</a>  [  <a href="#bit">&lt;bit&gt;</a>  ...  ]  <a href="#quote">&lt;quote&gt;</a>  [  {  <a href="#separator">&lt;separator&gt;</a> ...  <a href="#quote">&lt;quote&gt;</a>  [  <a href="#bit">&lt;bit&gt;</a> ...  ]  <a href="#quote">&lt;quote&gt;</a>  }...  ]</p><p><a name="bit"> &nbsp; </a><a href="#xref-bit"> &lt;bit&gt; </a>&nbsp;&nbsp;&nbsp;::=&nbsp;&nbsp; <a href="#xref-0"> 0 </a>  |  <a href="#xref-1"> 1 </a></p><p><a name="hex string literal"> &nbsp; </a><a href="#xref-hex%20string%20literal"> &lt;hex string literal&gt; </a>&nbsp;&nbsp;&nbsp;::=<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <a href="#xref-X"> X </a>  <a href="#quote">&lt;quote&gt;</a>  [  <a href="#hexit">&lt;hexit&gt;</a>  ...  ]  <a href="#quote">&lt;quote&gt;</a>  [  {  <a href="#separator">&lt;separator&gt;</a> ...  <a href="#quote">&lt;quote&gt;</a>  [  <a href="#hexit">&lt;hexit&gt;</a> ...  ]  <a href="#quote">&lt;quote&gt;</a>  }...  ]</p><p><a name="hexit"> &nbsp; </a><a href="#xref-hexit"> &lt;hexit&gt; </a>&nbsp;&nbsp;&nbsp;::=&nbsp;&nbsp; <a href="#digit">&lt;digit&gt;</a>  |  <a href="#xref-A"> A </a>  |  <a href="#xref-B"> B </a>  |  <a href="#xref-C"> C </a>  |  <a href="#xref-D"> D </a>  |  <a href="#xref-E"> E </a>  |  <a href="#xref-F"> F </a>  |  <a href="#xref-a"> a </a>  |  <a href="#xref-b"> b </a>  |  <a href="#xref-c"> c </a>  |  <a href="#xref-d"> d </a>  |  <a href="#xref-e"> e </a>  |  <a href="#xref-f"> f </a></p><p><a name="delimiter token"> &nbsp; </a><a href="#xref-delimiter%20token"> &lt;delimiter token&gt; </a>&nbsp;&nbsp;&nbsp;::=<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <a href="#character%20string%20literal">&lt;character string literal&gt;</a><br>&nbsp;&nbsp;&nbsp;&nbsp; |&nbsp;&nbsp;&nbsp;&nbsp; <a href="#date%20string">&lt;date string&gt;</a><br>&nbsp;&nbsp;&nbsp;&nbsp; |&nbsp;&nbsp;&nbsp;&nbsp; <a href="#time%20string">&lt;time string&gt;</a><br>&nbsp;&nbsp;&nbsp;&nbsp; |&nbsp;&nbsp;&nbsp;&nbsp; <a href="#timestamp%20string">&lt;timestamp string&gt;</a><br>&nbsp;&nbsp;&nbsp;&nbsp; |&nbsp;&nbsp;&nbsp;&nbsp; <a href="#delimited%20identifier">&lt;delimited identifier&gt;</a><br>&nbsp;&nbsp;&nbsp;&nbsp; |&nbsp;&nbsp;&nbsp;&nbsp; <a href="#SQL%20special%20character">&lt;SQL special character&gt;</a><br>&nbsp;&nbsp;&nbsp;&nbsp; |&nbsp;&nbsp;&nbsp;&nbsp; <a href="#not%20equals%20operator">&lt;not equals operator&gt;</a><br>&nbsp;&nbsp;&nbsp;&nbsp; |&nbsp;&nbsp;&nbsp;&nbsp; <a href="#greater%20than%20or%20equals%20operator">&lt;greater than or equals operator&gt;</a><br>&nbsp;&nbsp;&nbsp;&nbsp; |&nbsp;&nbsp;&nbsp;&nbsp; <a href="#less%20than%20or%20equals%20operator">&lt;less than or equals operator&gt;</a><br>&nbsp;&nbsp;&nbsp;&nbsp; |&nbsp;&nbsp;&nbsp;&nbsp; <a href="#concatenation%20operator">&lt;concatenation operator&gt;</a><br>&nbsp;&nbsp;&nbsp;&nbsp; |&nbsp;&nbsp;&nbsp;&nbsp; <a href="#double%20period">&lt;double period&gt;</a><br>&nbsp;&nbsp;&nbsp;&nbsp; |&nbsp;&nbsp;&nbsp;&nbsp; <a href="#left%20bracket">&lt;left bracket&gt;</a><br>&nbsp;&nbsp;&nbsp;&nbsp; |&nbsp;&nbsp;&nbsp;&nbsp; <a href="#right%20bracket">&lt;right bracket&gt;</a></p><p><a name="character string literal"> &nbsp; </a><a href="#xref-character%20string%20literal"> &lt;character string literal&gt; </a>&nbsp;&nbsp;&nbsp;::=<br>&nbsp;&nbsp;&nbsp;&nbsp; [  <a href="#introducer">&lt;introducer&gt;</a> <a href="#character%20set%20specification">&lt;character set specification&gt;</a>  ]  <a href="#quote">&lt;quote&gt;</a>  [  <a href="#character%20representation">&lt;character representation&gt;</a> ...  ]  <a href="#quote">&lt;quote&gt;</a>  [  {  <a href="#separator">&lt;separator&gt;</a> ...  <a href="#quote">&lt;quote&gt;</a>  [  <a href="#character%20representation">&lt;character representation&gt;</a> ...  ]  <a href="#quote">&lt;quote&gt;</a>  }...  ]</p><p><a name="introducer"> &nbsp; </a><a href="#xref-introducer"> &lt;introducer&gt; </a>&nbsp;&nbsp;&nbsp;::=&nbsp;&nbsp; <a href="#underscore">&lt;underscore&gt;</a></p><p><a name="character set specification"> &nbsp; </a><a href="#xref-character%20set%20specification"> &lt;character set specification&gt; </a>&nbsp;&nbsp;&nbsp;::=<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <a href="#standard%20character%20repertoire%20name">&lt;standard character repertoire name&gt;</a><br>&nbsp;&nbsp;&nbsp;&nbsp; |&nbsp;&nbsp;&nbsp;&nbsp; <a href="#implementation-defined%20character%20repertoire%20name">&lt;implementation-defined character repertoire name&gt;</a><br>&nbsp;&nbsp;&nbsp;&nbsp; |&nbsp;&nbsp;&nbsp;&nbsp; <a href="#user-defined%20character%20repertoire%20name">&lt;user-defined character repertoire name&gt;</a><br>&nbsp;&nbsp;&nbsp;&nbsp; |&nbsp;&nbsp;&nbsp;&nbsp; <a href="#standard%20universal%20character%20form-of-use%20name">&lt;standard universal character form-of-use name&gt;</a><br>&nbsp;&nbsp;&nbsp;&nbsp; |&nbsp;&nbsp;&nbsp;&nbsp; <a href="#implementation-defined%20universal%20character%20form-of-use%20name">&lt;implementation-defined universal character form-of-use name&gt;</a></p><p><a name="standard character repertoire name"> &nbsp; </a><a href="#xref-standard%20character%20repertoire%20name"> &lt;standard character repertoire name&gt; </a>&nbsp;&nbsp;&nbsp;::=&nbsp;&nbsp; <a href="#character%20set%20name">&lt;character set name&gt;</a></p><p><a name="character set name"> &nbsp; </a><a href="#xref-character%20set%20name"> &lt;character set name&gt; </a>&nbsp;&nbsp;&nbsp;::=&nbsp;&nbsp; [  <a href="#schema%20name">&lt;schema name&gt;</a>  <a href="#period">&lt;period&gt;</a>  ]  <a href="#SQL%20language%20identifier">&lt;SQL language identifier&gt;</a>

⌨️ 快捷键说明

复制代码Ctrl + C
搜索代码Ctrl + F
全屏模式F11
增大字号Ctrl + =
减小字号Ctrl + -
显示快捷键?