?? sql-2003-2.bnf.html
字號:
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<!-- Generated HTML - Modify at your own peril! -->
<html>
<head>
<title> BNF Grammar for ISO/IEC 9075-2:2003 - Database Language SQL (SQL-2003) SQL/Foundation </title>
</head>
<body>
<h1> BNF Grammar for ISO/IEC 9075-2:2003 - Database Language SQL (SQL-2003) SQL/Foundation </h1>
<a name="top"> </a>
<br>
<a href="#xref-rules"> Cross-Reference: rules </a>
<br>
<a href="#xref-keywords"> Cross-Reference: keywords </a>
<br>
<p><font color=green><i><small>
Derived from file sql-2003-2.bnf version 1.11 dated 2005/07/13 18:37:30
<br>
Generated on 2005-07-13 18:37:56+00:00 by file bnf2html.pl version 3.7 dated 2005/07/13 18:32:35
</small></i></font></p>
<p>
Information taken from the Final Committee Draft (FCD) of ISO/IEC 9075-2:2003.
However, the page numbers and some section titles (9.14 through 9.23,
for example) are from the final standard.
This means there could be other as yet undiagnosed differences between
the final standard and the notation in this document; you were warned!
</p>
<p>
The plain text version of this grammar is
<a href='sql-2003-2.bnf'> sql-2003-2.bnf </a>.
</p>
<hr>
<h2> Key SQL Statements and Fragments
</h2>
<bl>
<li> ALTER DOMAIN <a href='#alter domain statement'><alter domain statement></a>
<li> ALTER TABLE <a href='#alter table statement'><alter table statement></a>
<li> CLOSE cursor <a href='#close statement'><close statement></a>
<li> Column definition <a href='#column definition'><column definition></a>
<li> COMMIT WORK <a href='#commit statement'><commit statement></a>
<li> CONNECT <a href='#connect statement'><connect statement></a>
<li> CREATE ASSERTION <a href='#assertion definition'><assertion definition></a>
<li> CREATE CHARACTER SET <a href='#character set definition'><character set definition></a>
<li> CREATE COLLATION <a href='#collation definition'><collation definition></a>
<li> CREATE DOMAIN <a href='#domain definition'><domain definition></a>
<li> CREATE FUNCTION <a href='#schema function'><schema function></a>
<li> CREATE PROCEDURE <a href='#schema procedure'><schema procedure></a>
<li> CREATE SCHEMA <a href='#schema definition'><schema definition></a>
<li> CREATE TABLE <a href='#table definition'><table definition></a>
<li> CREATE TRANSLATION <a href='#translation definition'><translation definition></a>
<li> CREATE TRIGGER <a href='#trigger definition'><trigger definition></a>
<li> CREATE VIEW <a href='#view definition'><view definition></a>
<li> Data type <a href='#data type'><data type></a>
<li> DEALLOCATE PREPARE <a href='#deallocate prepared statement'><deallocate prepared statement></a>
<li> DECLARE cursor <a href='#declare cursor'><declare cursor></a> <a href='#dynamic declare cursor'><dynamic declare cursor></a>
<li> DECLARE LOCAL TEMPORARY TABLE <a href='#temporary table declaration'><temporary table declaration></a>
<li> DELETE <a href='#delete statement: positioned'><delete statement: positioned></a> <a href='#delete statement: searched'><delete statement: searched></a> <a href='#dynamic delete statement: positioned'><dynamic delete statement: positioned></a>
<li> DESCRIBE <a href='#describe statement'><describe statement></a>
<li> DESCRIPTOR statements <a href='#system descriptor statement'><system descriptor statement></a>
<li> DISCONNECT <a href='#disconnect statement'><disconnect statement></a>
<li> EXECUTE <a href='#execute statement'><execute statement></a>
<li> EXECUTE IMMEDIATE <a href='#execute immediate statement'><execute immediate statement></a>
<li> FETCH cursor <a href='#fetch statement'><fetch statement></a>
<li> FROM clause <a href='#from clause'><from clause></a>
<li> GET DIAGNOSTICS <a href='#get diagnostics statement'><get diagnostics statement></a>
<li> GRANT <a href='#grant statement'><grant statement></a>
<li> GROUP BY clause <a href='#group by clause'><group by clause></a>
<li> HAVING clause <a href='#having clause'><having clause></a>
<li> INSERT <a href='#insert statement'><insert statement></a>
<li> Literals <a href='#literal'><literal></a>
<li> Keywords <a href='#key word'><key word></a>
<li> MERGE <a href='#merge statement'><merge statement></a>
<li> OPEN cursor <a href='#open statement'><open statement></a>
<li> ORDER BY clause <a href='#order by clause'><order by clause></a>
<li> PREPARE <a href='#prepare statement'><prepare statement></a>
<li> REVOKE <a href='#revoke statement'><revoke statement></a>
<li> ROLLBACK WORK <a href='#rollback statement'><rollback statement></a>
<li> SAVEPOINT <a href='#savepoint statement'><savepoint statement></a>
<li> Search condition <a href='#search condition'><search condition></a> <a href='#regular expression'><regular expression></a>
<li> SELECT <a href='#query specification'><query specification></a>
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -