Today I found a good site that displays the ORACLE syntax. Too much content, not 11 extract, remember here, also convenient to find their own.
The table of contents is as follows:
An A-Z Index of Oracle SQL Commands (version 9.2)
ANALYZE AUDIT
CALL
Cluster - CREATE CLUSTER
- ALTER CLUSTER
- DROP CLUSTER
COMMENT COMMIT CONNECT CONSTRAINT - Add / Enable Context - CREATE CONTEXT - DROP CONTEXT Controlfile - CREATE CONTROLFILE
Database - CREATE DATABASE - ALTER DATABASE DELETE DESCRIBE Dimension - CREATE DIMENSION - ALTER DIMENSION - DROP DIMENSION Directory - CREATE DIRECTORY - DROP DIRECTORY
EXEC EXECUTE IMMEDIATE EXPLAIN PLAN
Function - CREATE FUNCTION - ALTER FUNCTION - DROP FUNCTION
GRANT
Index - CREATE INDEX - ALTER INDEX - DROP INDEX Indextype - CREATE INDEXTYPE - DROP INDEXTYPE INSERT INTERSECT
Java - CREATE JAVA - ALTER JAVA - DROP JAVA
Library - CREATE LIBRARY - DROP LIBRARY Link - CREATE DATABASE LINK - DROP DATABASE LINK LOCK TABLE
Mview - CREATE MATERIALIZED VIEW - ALTER MATERIALIZED VIEW - DROP MATERIALIZED VIEW - CREATE MATERIALIZED VIEW LOG - ALTER MATERIALIZED VIEW LOG - DROP MATERIALIZED VIEW LOG MINUS
NOAUDIT
Operator - CREATE OPERATOR - DROP OPERATOR Outline - CREATE OUTLINE - ALTER OUTLINE - DROP OUTLINE
Package - CREATE PACKAGE/BODY - ALTER PACKAGE - DROP PACKAGE Pfile - CREATE PFILE Procedure - CREATE PROCEDURE - ALTER PROCEDURE - DROP PROCEDURE Profile - CREATE PROFILE - ALTER PROFILE - DROP PROFILE
RECOVER RENAME Resource - ALTER RESOURCE COST REVOKE RMAN - Recovery Manager Role - CREATE ROLE - SET ROLE - ALTER ROLE - DROP ROLE ROLLBACK Rollback - CREATE ROLLBACK SEGMENT - ALTER ROLLBACK SEGMENT - DROP ROLLBACK SEGMENT
SAVEPOINT Schema - CREATE SCHEMA SELECT Sequence - CREATE SEQUENCE - ALTER SEQUENCE - DROP SEQUENCE Session - ALTER SESSION SHUTDOWN SNAPSHOT SPfile - CREATE SPFILE STARTUP Statistics - ASSOCIATE STATISTICS - DISASSOCIATE STATISTICS Synonym - CREATE SYNONYM - DROP SYNONYM System - ALTER SYSTEM
Table - CREATE TABLE - ALTER TABLE - DROP TABLE Tablespace - CREATE TABLESPACE - ALTER TABLESPACE - DROP TABLESPACE - CREATE TEMPORARY TABLESPACE Transaction - SET TRANSACTION Trigger - CREATE TRIGGER - ALTER TRIGGER - DROP TRIGGER TRUNCATE Type - CREATE TYPE - ALTER TYPE - DROP TYPE - CREATE TYPE BODY - DROP TYPE BODY
UPDATE UNION User - CREATE USER - ALTER USER - DROP USER
View - CREATE VIEW - ALTER VIEW - DROP VIEW