今天发现了一个显示ORACLE语法的好网站。内容太多，就不一一摘录了，记在这里，也方便自己查找。 [url=http://www.ss64.com/ora/]http://www.ss64.com/ora/[/url] 目录如下： An A-Z Index of Oracle SQL Commands (version 9.2) [url=http://www.ss64.com/ora/analyze.html]ANALYZE[/url] [url=http://www.ss64.com/ora/audit.html]AUDIT[/url] [url=http://www.ss64.com/ora/call.html]CALL[/url] Cluster - [url=http://www.ss64.com/ora/cluster_c.html]CREATE CLUSTER[/url]         - [url=http://www.ss64.com/ora/cluster_a.html]ALTER  CLUSTER[/url]         - [url=http://www.ss64.com/ora/cluster_d.html]DROP   CLUSTER[/url] [url=http://www.ss64.com/ora/comment.html]COMMENT[/url] [url=http://www.ss64.com/ora/commit.html]COMMIT[/url] [url=http://www.ss64.com/ora/connect.html]CONNECT[/url] [url=http://www.ss64.com/ora/table_a.html]CONSTRAINT[/url] - Add / Enable Context - [url=http://www.ss64.com/ora/context_c.html]CREATE CONTEXT[/url]         - [url=http://www.ss64.com/ora/context_d.html]DROP CONTEXT[/url] Controlfile - [url=http://www.ss64.com/ora/controlfile_c.html]CREATE CONTROLFILE[/url] Database - [url=http://www.ss64.com/ora/database_c.html]CREATE DATABASE[/url]          - [url=http://www.ss64.com/ora/database_a.html]ALTER  DATABASE[/url] [url=http://www.ss64.com/ora/delete.html]DELETE[/url] [url=http://www.ss64.com/ora/desc.html]DESC[/url]RIBE Dimension - [url=http://www.ss64.com/ora/dimension_c.html]CREATE DIMENSION[/url]           - [url=http://www.ss64.com/ora/dimension_a.html]ALTER DIMENSION[/url]           - [url=http://www.ss64.com/ora/dimension_d.html]DROP DIMENSION[/url] Directory - [url=http://www.ss64.com/ora/directory_c.html]CREATE DIRECTORY[/url]           - [url=http://www.ss64.com/ora/directory_d.html]DROP DIRECTORY[/url] [url=http://www.ss64.com/ora/exec.html]EXEC[/url] [url=http://www.ss64.com/ora/exec_imm.html]EXECUTE IMMEDIATE[/url] [url=http://www.ss64.com/ora/explain.html]EXPLAIN PLAN[/url] Function - [url=http://www.ss64.com/ora/function_c.html]CREATE FUNCTION[/url]          - [url=http://www.ss64.com/ora/function_a.html]ALTER  FUNCTION[/url]          - [url=http://www.ss64.com/ora/function_d.html]DROP   FUNCTION[/url] [url=http://www.ss64.com/ora/grant.html]GRANT[/url] Index - [url=http://www.ss64.com/ora/index_c.html]CREATE INDEX[/url]       - [url=http://www.ss64.com/ora/index_a.html]ALTER  INDEX[/url]       - [url=http://www.ss64.com/ora/index_d.html]DROP   INDEX[/url] Indextype - [url=http://www.ss64.com/ora/indextype_c.html]CREATE INDEXTYPE[/url]           - [url=http://www.ss64.com/ora/indextype_d.html]DROP INDEXTYPE[/url] [url=http://www.ss64.com/ora/insert.html]INSERT[/url] [url=http://www.ss64.com/ora/union.html]INTERSECT[/url] Java - [url=http://www.ss64.com/ora/java_c.html]CREATE JAVA[/url]      - [url=http://www.ss64.com/ora/java_a.html]ALTER JAVA[/url]      - [url=http://www.ss64.com/ora/java_d.html]DROP JAVA[/url] Library - [url=http://www.ss64.com/ora/library_c.html]CREATE LIBRARY[/url]         - [url=http://www.ss64.com/ora/library_d.html]DROP LIBRARY[/url] Link - [url=http://www.ss64.com/ora/link_c.html]CREATE DATABASE LINK[/url]      - [url=http://www.ss64.com/ora/link_d.html]DROP DATABASE LINK[/url] [url=http://www.ss64.com/ora/lock.html]LOCK TABLE[/url] Mview - [url=http://www.ss64.com/ora/mview_c.html]CREATE MATERIALIZED VIEW[/url]       - [url=http://www.ss64.com/ora/mview_a.html]ALTER MATERIALIZED VIEW[/url]       - [url=http://www.ss64.com/ora/mview_d.html]DROP MATERIALIZED VIEW[/url]       - [url=http://www.ss64.com/ora/mview_log_c.html]CREATE MATERIALIZED VIEW LOG[/url]       - [url=http://www.ss64.com/ora/mview_log_a.html]ALTER MATERIALIZED VIEW LOG[/url]       - [url=http://www.ss64.com/ora/mview_log_d.html]DROP MATERIALIZED VIEW LOG[/url] [url=http://www.ss64.com/ora/union.html]MINUS[/url] [url=http://www.ss64.com/ora/noaudit.html]NOAUDIT[/url] Operator - CREATE OPERATOR          - DROP OPERATOR Outline - [url=http://www.ss64.com/ora/outline_c.html]CREATE OUTLINE[/url]         - [url=http://www.ss64.com/ora/outline_a.html]ALTER OUTLINE[/url]         - [url=http://www.ss64.com/ora/outline_d.html]DROP OUTLINE[/url] Package - [url=http://www.ss64.com/ora/package_c.html]CREATE PACKAGE/BODY[/url]         - [url=http://www.ss64.com/ora/package_a.html]ALTER  PACKAGE[/url]         - [url=http://www.ss64.com/ora/package_d.html]DROP   PACKAGE[/url] Pfile - [url=http://www.ss64.com/ora/pfile.html]CREATE PFILE[/url] Procedure - [url=http://www.ss64.com/ora/procedure_c.html]CREATE PROCEDURE[/url]           - [url=http://www.ss64.com/ora/procedure_a.html]ALTER  PROCEDURE[/url]           - [url=http://www.ss64.com/ora/procedure_d.html]DROP   PROCEDURE[/url] Profile - [url=http://www.ss64.com/ora/profile_c.html]CREATE PROFILE[/url]         - [url=http://www.ss64.com/ora/profile_a.html]ALTER  PROFILE[/url]         - [url=http://www.ss64.com/ora/profile_d.html]DROP   PROFILE[/url] [url=http://www.ss64.com/ora/recover.html]RECOVER[/url] [url=http://www.ss64.com/ora/rename.html]RENAME[/url] Resource - [url=http://www.ss64.com/ora/resource_a.html]ALTER RESOURCE COST[/url] [url=http://www.ss64.com/ora/revoke.html]REVOKE[/url] [url=http://www.ss64.com/ora/rman.html]RMAN[/url] - Recovery Manager Role - [url=http://www.ss64.com/ora/role_c.html]CREATE ROLE[/url]      - [url=http://www.ss64.com/ora/role_s.html]SET    ROLE[/url]      - [url=http://www.ss64.com/ora/role_a.html]ALTER  ROLE[/url]      - [url=http://www.ss64.com/ora/role_d.html]DROP   ROLE[/url] [url=http://www.ss64.com/ora/rollback.html]ROLLBACK[/url] Rollback - [url=http://www.ss64.com/ora/rollback_c.html]CREATE ROLLBACK SEGMENT[/url]          - [url=http://www.ss64.com/ora/rollback_a.html]ALTER  ROLLBACK SEGMENT[/url]          - [url=http://www.ss64.com/ora/rollback_d.html]DROP   ROLLBACK SEGMENT[/url] [url=http://www.ss64.com/ora/savepoint.html]SAVEPOINT[/url] Schema - [url=http://www.ss64.com/ora/schema_c.html]CREATE SCHEMA[/url] [url=http://www.ss64.com/ora/select.html]SELECT[/url] Sequence - [url=http://www.ss64.com/ora/sequence_c.html]CREATE SEQUENCE[/url]          - [url=http://www.ss64.com/ora/sequence_a.html]ALTER  SEQUENCE[/url]          - [url=http://www.ss64.com/ora/sequence_d.html]DROP   SEQUENCE[/url] Session - [url=http://www.ss64.com/ora/session_a.html]ALTER SESSION[/url] [url=http://www.ss64.com/ora/shutdown.html]SHUTDOWN[/url] [url=http://www.ss64.com/ora/snapshot.html]SNAPSHOT[/url] SPfile - [url=http://www.ss64.com/ora/spfile.html]CREATE SPFILE[/url] [url=http://www.ss64.com/ora/startup.html]STARTUP[/url] Statistics - [url=http://www.ss64.com/ora/stats_assoc.html]ASSOCIATE STATISTICS[/url]            - [url=http://www.ss64.com/ora/stats_dis.html]DISASSOCIATE STATISTICS[/url] Synonym - [url=http://www.ss64.com/ora/syn_c.html]CREATE SYNONYM[/url]         - [url=http://www.ss64.com/ora/syn_d.html]DROP   SYNONYM[/url] System - [url=http://www.ss64.com/ora/system_a.html]ALTER SYSTEM[/url] Table - [url=http://www.ss64.com/ora/table_c.html]CREATE TABLE[/url]       - [url=http://www.ss64.com/ora/table_a.html]ALTER  TABLE[/url]       - [url=http://www.ss64.com/ora/table_d.html]DROP   TABLE[/url] Tablespace - [url=http://www.ss64.com/ora/tablespace_c.html]CREATE TABLESPACE[/url]            - [url=http://www.ss64.com/ora/tablespace_a.html]ALTER  TABLESPACE[/url]            - [url=http://www.ss64.com/ora/tablespace_d.html]DROP   TABLESPACE[/url]            - [url=http://www.ss64.com/ora/temp_tspace_c.html]CREATE TEMPORARY TABLESPACE[/url] Transaction - [url=http://www.ss64.com/ora/transaction_s.html]SET TRANSACTION[/url] Trigger - [url=http://www.ss64.com/ora/trigger_c.html]CREATE TRIGGER[/url]         - [url=http://www.ss64.com/ora/trigger_a.html]ALTER  TRIGGER[/url]         - [url=http://www.ss64.com/ora/trigger_d.html]DROP   TRIGGER[/url] [url=http://www.ss64.com/ora/truncate.html]TRUNCATE[/url] Type - CREATE TYPE      - ALTER TYPE      - DROP TYPE      - CREATE TYPE BODY      - DROP TYPE BODY [url=http://www.ss64.com/ora/update.html]UPDATE[/url] [url=http://www.ss64.com/ora/union.html]UNION[/url] User - [url=http://www.ss64.com/ora/user_c.html]CREATE USER[/url]      - [url=http://www.ss64.com/ora/user_a.html]ALTER  USER[/url]      - [url=http://www.ss64.com/ora/user_d.html]DROP   USER[/url] View - [url=http://www.ss64.com/ora/view_c.html]CREATE VIEW[/url]      - [url=http://www.ss64.com/ora/view_a.html]ALTER  VIEW[/url]      - [url=http://www.ss64.com/ora/view_d.html]DROP   VIEW[/url]