sql-92.bnf.html

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

<a href="#xref-year-month%20literal"> &lt;year-month literal&gt; </a>&nbsp;&nbsp;&nbsp;::=
<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <a href="#years%20value">&lt;years value&gt;</a><br>&nbsp;&nbsp;&nbsp;&nbsp; |&nbsp;&nbsp;&nbsp;&nbsp; [  <a href="#years%20value">&lt;years value&gt;</a>  <a href="#minus%20sign">&lt;minus sign&gt;</a>  ]  <a href="#months%20value">&lt;months value&gt;</a>
</p><p><a name="day-time literal"> &nbsp; </a>
<a href="#xref-day-time%20literal"> &lt;day-time literal&gt; </a>&nbsp;&nbsp;&nbsp;::=&nbsp;&nbsp; <a href="#day-time%20interval">&lt;day-time interval&gt;</a>  |  <a href="#time%20interval">&lt;time interval&gt;</a>

</p><p><a name="day-time interval"> &nbsp; </a>
<a href="#xref-day-time%20interval"> &lt;day-time interval&gt; </a>&nbsp;&nbsp;&nbsp;::=
<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <a href="#days%20value">&lt;days value&gt;</a>  [  <a href="#space">&lt;space&gt;</a>  <a href="#hours%20value">&lt;hours value&gt;</a>  [  <a href="#colon">&lt;colon&gt;</a>  <a href="#minutes%20value">&lt;minutes value&gt;</a>  [  <a href="#colon">&lt;colon&gt;</a>  <a href="#seconds%20value">&lt;seconds value&gt;</a>  ]  ]  ]
</p><p><a name="time-interval"> &nbsp; </a>
<a href="#xref-time-interval"> &lt;time-interval&gt; </a>&nbsp;&nbsp;&nbsp;::=
<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <a href="#hours%20value">&lt;hours value&gt;</a>  [  <a href="#colon">&lt;colon&gt;</a>  <a href="#minutes%20value">&lt;minutes value&gt;</a>  [  <a href="#colon">&lt;colon&gt;</a>  <a href="#seconds%20value">&lt;seconds value&gt;</a>  ]  ]<br>&nbsp;&nbsp;&nbsp;&nbsp; |&nbsp;&nbsp;&nbsp;&nbsp; <a href="#minutes%20value">&lt;minutes value&gt;</a>  [  <a href="#colon">&lt;colon&gt;</a>  <a href="#seconds%20value">&lt;seconds value&gt;</a>  ]<br>&nbsp;&nbsp;&nbsp;&nbsp; |&nbsp;&nbsp;&nbsp;&nbsp; <a href="#seconds%20value">&lt;seconds value&gt;</a>
</p><p><a name="not equals operator"> &nbsp; </a>
<a href="#xref-not%20equals%20operator"> &lt;not equals operator&gt; </a>&nbsp;&nbsp;&nbsp;::=&nbsp;&nbsp; &lt;&gt;

</p><p><a name="greater than or equals operator"> &nbsp; </a>
<a href="#xref-greater%20than%20or%20equals%20operator"> &lt;greater than or equals operator&gt; </a>&nbsp;&nbsp;&nbsp;::=&nbsp;&nbsp; &gt;=

</p><p><a name="less than or equals operator"> &nbsp; </a>
<a href="#xref-less%20than%20or%20equals%20operator"> &lt;less than or equals operator&gt; </a>&nbsp;&nbsp;&nbsp;::=&nbsp;&nbsp; &lt;=

</p><p><a name="concatenation operator"> &nbsp; </a>
<a href="#xref-concatenation%20operator"> &lt;concatenation operator&gt; </a>&nbsp;&nbsp;&nbsp;::=&nbsp;&nbsp; ||

</p><p><a name="double period"> &nbsp; </a>
<a href="#xref-double%20period"> &lt;double period&gt; </a>&nbsp;&nbsp;&nbsp;::=&nbsp;&nbsp; ..

</p><p><a href="#top">Top</a></p>

<hr>
<h2> SQL Module
</h2>

<p><a name="module"> &nbsp; </a>
<a href="#xref-module"> &lt;module&gt; </a>&nbsp;&nbsp;&nbsp;::=
<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <a href="#module%20name%20clause">&lt;module name clause&gt;</a>  <a href="#language%20clause">&lt;language clause&gt;</a>  <a href="#module%20authorization%20clause">&lt;module authorization clause&gt;</a><br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; [  <a href="#temporary%20table%20declaration">&lt;temporary table declaration&gt;</a> ...  ]<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <a href="#module%20contents">&lt;module contents&gt;</a> ...
</p><p><a name="module name clause"> &nbsp; </a>
<a href="#xref-module%20name%20clause"> &lt;module name clause&gt; </a>&nbsp;&nbsp;&nbsp;::=
<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <a href="#xref-MODULE"> MODULE </a>  [  <a href="#module%20name">&lt;module name&gt;</a>  ]  [  <a href="#module%20character%20set%20specification">&lt;module character set specification&gt;</a>  ]
</p><p><a name="module name"> &nbsp; </a>
<a href="#xref-module%20name"> &lt;module name&gt; </a>&nbsp;&nbsp;&nbsp;::=&nbsp;&nbsp; <a href="#identifier">&lt;identifier&gt;</a>

</p><p><a name="module character set specification"> &nbsp; </a>
<a href="#xref-module%20character%20set%20specification"> &lt;module character set specification&gt; </a>&nbsp;&nbsp;&nbsp;::=&nbsp;&nbsp; <a href="#xref-NAMES"> NAMES </a>  <a href="#xref-ARE"> ARE </a>  <a href="#character%20set%20specification">&lt;character set specification&gt;</a>

</p><p><a name="language clause"> &nbsp; </a>
<a href="#xref-language%20clause"> &lt;language clause&gt; </a>&nbsp;&nbsp;&nbsp;::=&nbsp;&nbsp; <a href="#xref-LANGUAGE"> LANGUAGE </a>  <a href="#language%20name">&lt;language name&gt;</a>

</p><p><a name="language name"> &nbsp; </a>
<a href="#xref-language%20name"> &lt;language name&gt; </a>&nbsp;&nbsp;&nbsp;::=&nbsp;&nbsp; <a href="#xref-ADA"> ADA </a>  |  <a href="#xref-C"> C </a>  |  <a href="#xref-COBOL"> COBOL </a>  |  <a href="#xref-FORTRAN"> FORTRAN </a>  |  <a href="#xref-MUMPS"> MUMPS </a>  |  <a href="#xref-PASCAL"> PASCAL </a>  |  <a href="#xref-PLI"> PLI </a>

</p><p><a name="module authorization clause"> &nbsp; </a>
<a href="#xref-module%20authorization%20clause"> &lt;module authorization clause&gt; </a>&nbsp;&nbsp;&nbsp;::=
<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <a href="#xref-SCHEMA"> SCHEMA </a>  <a href="#schema%20name">&lt;schema name&gt;</a><br>&nbsp;&nbsp;&nbsp;&nbsp; |&nbsp;&nbsp;&nbsp;&nbsp; <a href="#xref-AUTHORIZATION"> AUTHORIZATION </a>  <a href="#module%20authorization%20identifier">&lt;module authorization identifier&gt;</a><br>&nbsp;&nbsp;&nbsp;&nbsp; |&nbsp;&nbsp;&nbsp;&nbsp; <a href="#xref-SCHEMA"> SCHEMA </a>  <a href="#schema%20name">&lt;schema name&gt;</a>  <a href="#xref-AUTHORIZATION"> AUTHORIZATION </a>  <a href="#module%20authorization%20identifier">&lt;module authorization identifier&gt;</a>
</p><p><a name="module authorization identifier"> &nbsp; </a>
<a href="#xref-module%20authorization%20identifier"> &lt;module authorization identifier&gt; </a>&nbsp;&nbsp;&nbsp;::=&nbsp;&nbsp; <a href="#authorization%20identifier">&lt;authorization identifier&gt;</a>

</p><p><a name="authorization identifier"> &nbsp; </a>
<a href="#xref-authorization%20identifier"> &lt;authorization identifier&gt; </a>&nbsp;&nbsp;&nbsp;::=&nbsp;&nbsp; <a href="#identifier">&lt;identifier&gt;</a>

</p><p><a name="temporary table declaration"> &nbsp; </a>
<a href="#xref-temporary%20table%20declaration"> &lt;temporary table declaration&gt; </a>&nbsp;&nbsp;&nbsp;::=
<br>&nbsp;&nbsp;&nbsp;&nbsp; <a href="#xref-DECLARE"> DECLARE </a>  <a href="#xref-LOCAL"> LOCAL </a>  <a href="#xref-TEMPORARY"> TEMPORARY </a>  <a href="#xref-TABLE"> TABLE </a>  <a href="#qualified%20local%20table%20name">&lt;qualified local table name&gt;</a>  <a href="#table%20element%20list">&lt;table element list&gt;</a>  [  <a href="#xref-ON"> ON </a>  <a href="#xref-COMMIT"> COMMIT </a>  {  <a href="#xref-PRESERVE"> PRESERVE </a>  |  <a href="#xref-DELETE"> DELETE </a>  }  <a href="#xref-ROWS"> ROWS </a>  ]
</p><p><a name="qualified local table name"> &nbsp; </a>
<a href="#xref-qualified%20local%20table%20name"> &lt;qualified local table name&gt; </a>&nbsp;&nbsp;&nbsp;::=&nbsp;&nbsp; <a href="#xref-MODULE"> MODULE </a>  <a href="#period">&lt;period&gt;</a>  <a href="#local%20table%20name">&lt;local table name&gt;</a>

</p><p><a name="local table name"> &nbsp; </a>
<a href="#xref-local%20table%20name"> &lt;local table name&gt; </a>&nbsp;&nbsp;&nbsp;::=&nbsp;&nbsp; <a href="#qualified%20identifier">&lt;qualified identifier&gt;</a>

</p><p><a name="qualified identifier"> &nbsp; </a>
<a href="#xref-qualified%20identifier"> &lt;qualified identifier&gt; </a>&nbsp;&nbsp;&nbsp;::=&nbsp;&nbsp; <a href="#identifier">&lt;identifier&gt;</a>

</p><p><a name="table element list"> &nbsp; </a>
<a href="#xref-table%20element%20list"> &lt;table element list&gt; </a>&nbsp;&nbsp;&nbsp;::=&nbsp;&nbsp; <a href="#left%20paren">&lt;left paren&gt;</a>  <a href="#table%20element">&lt;table element&gt;</a>  [  {  <a href="#comma">&lt;comma&gt;</a>  <a href="#table%20element">&lt;table element&gt;</a>  }...  ]  <a href="#right%20paren">&lt;right paren&gt;</a>

</p><p><a name="table element"> &nbsp; </a>
<a href="#xref-table%20element"> &lt;table element&gt; </a>&nbsp;&nbsp;&nbsp;::=&nbsp;&nbsp; <a href="#column%20definition">&lt;column definition&gt;</a>  |  <a href="#table%20constraint%20definition">&lt;table constraint definition&gt;</a>

</p><p><a name="column definition"> &nbsp; </a>
<a href="#xref-column%20definition"> &lt;column definition&gt; </a>&nbsp;&nbsp;&nbsp;::=
<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <a href="#column%20name">&lt;column name&gt;</a>  {  <a href="#data%20type">&lt;data type&gt;</a>  |  <a href="#domain%20name">&lt;domain name&gt;</a>  }  [  <a href="#default%20clause">&lt;default clause&gt;</a>  ]  [  <a href="#column%20constraint%20definition">&lt;column constraint definition&gt;</a> ...  ]  [  <a href="#collate%20clause">&lt;collate clause&gt;</a>  ]
</p><p><a name="column name"> &nbsp; </a>
<a href="#xref-column%20name"> &lt;column name&gt; </a>&nbsp;&nbsp;&nbsp;::=&nbsp;&nbsp; <a href="#identifier">&lt;identifier&gt;</a>

</p><p><a href="#top">Top</a></p>

<hr>
<h2> Data Types
</h2>

<p><a name="data type"> &nbsp; </a>
<a href="#xref-data%20type"> &lt;data type&gt; </a>&nbsp;&nbsp;&nbsp;::=
<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <a href="#character%20string%20type">&lt;character string type&gt;</a>  [  <a href="#xref-CHARACTER"> CHARACTER </a>  <a href="#xref-SET"> SET </a>  <a href="#character%20set%20specification">&lt;character set specification&gt;</a>  ]<br>&nbsp;&nbsp;&nbsp;&nbsp; |&nbsp;&nbsp;&nbsp;&nbsp; <a href="#national%20character%20string%20type">&lt;national character string type&gt;</a><br>&nbsp;&nbsp;&nbsp;&nbsp; |&nbsp;&nbsp;&nbsp;&nbsp; <a href="#bit%20string%20type">&lt;bit string type&gt;</a><br>&nbsp;&nbsp;&nbsp;&nbsp; |&nbsp;&nbsp;&nbsp;&nbsp; <a href="#numeric%20type">&lt;numeric type&gt;</a><br>&nbsp;&nbsp;&nbsp;&nbsp; |&nbsp;&nbsp;&nbsp;&nbsp; <a href="#datetime%20type">&lt;datetime type&gt;</a><br>&nbsp;&nbsp;&nbsp;&nbsp; |&nbsp;&nbsp;&nbsp;&nbsp; <a href="#interval%20type">&lt;interval type&gt;</a>
</p><p><a name="character string type"> &nbsp; </a>
<a href="#xref-character%20string%20type"> &lt;character string type&gt; </a>&nbsp;&nbsp;&nbsp;::=
<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <a href="#xref-CHARACTER"> CHARACTER </a>  [  <a href="#left%20paren">&lt;left paren&gt;</a>  <a href="#length">&lt;length&gt;</a>  <a href="#right%20paren">&lt;right paren&gt;</a>  ]<br>&nbsp;&nbsp;&nbsp;&nbsp; |&nbsp;&nbsp;&nbsp;&nbsp; <a href="#xref-CHAR"> CHAR </a>  [  <a href="#left%20paren">&lt;left paren&gt;</a>  <a href="#length">&lt;length&gt;</a>  <a href="#right%20paren">&lt;right paren&gt;</a>  ]<br>&nbsp;&nbsp;&nbsp;&nbsp; |&nbsp;&nbsp;&nbsp;&nbsp; <a href="#xref-CHARACTER"> CHARACTER </a>  <a href="#xref-VARYING"> VARYING </a>  [  <a href="#left%20paren">&lt;left paren&gt;</a>  <a href="#length">&lt;length&gt;</a>  <a href="#right%20paren">&lt;right paren&gt;</a>  ]<br>&nbsp;&nbsp;&nbsp;&nbsp; |&nbsp;&nbsp;&nbsp;&nbsp; <a href="#xref-CHAR"> CHAR </a>  <a href="#xref-VARYING"> VARYING </a>  [  <a href="#left%20paren">&lt;left paren&gt;</a>  <a href="#length">&lt;length&gt;</a>  <a href="#right%20paren">&lt;right paren&gt;</a>  ]<br>&nbsp;&nbsp;&nbsp;&nbsp; |&nbsp;&nbsp;&nbsp;&nbsp; <a href="#xref-VARCHAR"> VARCHAR </a>  [  <a href="#left%20paren">&lt;left paren&gt;</a>  <a href="#length">&lt;length&gt;</a>  <a href="#right%20paren">&lt;right paren&gt;</a>  ]
</p><p><a name="length"> &nbsp; </a>
<a href="#xref-length"> &lt;length&gt; </a>&nbsp;&nbsp;&nbsp;::=&nbsp;&nbsp; <a href="#unsigned%20integer">&lt;unsigned integer&gt;</a>

</p><p><a name="national character string type"> &nbsp; </a>
<a href="#xref-national%20character%20string%20type"> &lt;national character string type&gt; </a>&nbsp;&nbsp;&nbsp;::=
<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <a href="#xref-NATIONAL"> NATIONAL </a>  <a href="#xref-CHARACTER"> CHARACTER </a>  [  <a href="#left%20paren">&lt;left paren&gt;</a>  <a href="#length">&lt;length&gt;</a>  <a href="#right%20paren">&lt;right paren&gt;</a>  ]<br>&nbsp;&nbsp;&nbsp;&nbsp; |&nbsp;&nbsp;&nbsp;&nbsp; <a href="#xref-NATIONAL"> NATIONAL </a>  <a href="#xref-CHAR"> CHAR </a>  [  <a href="#left%20paren">&lt;left paren&gt;</a>  <a href="#length">&lt;length&gt;</a>  <a href="#right%20paren">&lt;right paren&gt;</a>  ]<br>&nbsp;&nbsp;&nbsp;&nbsp; |&nbsp;&nbsp;&nbsp;&nbsp; <a href="#xref-NCHAR"> NCHAR </a>  [  <a href="#left%20paren">&lt;left paren&gt;</a>  <a href="#length">&lt;length&gt;</a>  <a href="#right%20paren