SQL REFERENSE Oracle 7.3.4
Contents
ALTER CLUSTER.. 4
ALTER DATABASE. 5
ALTER FUNCTION.. 6
ALTER INDEX.. 6
ALTER PACKAGE. 7
ALTER PROCEDURE. 7
ALTER PROFILE. 7
ALTER RESOURCE COST.. 8
ALTER ROLE. 8
ALTER ROLLBACK SEGMENT.. 8
ALTER SEQUENCE. 8
ALTER SESSION.. 9
ALTER SNAPSHOT.. 10
ALTER SNAPSHOT LOG.. 10
ALTER SYSTEM... 10
ALTER TABLE. 11
ALTER TABLESPACE. 12
ALTER TRIGGER.. 12
ALTER USER.. 12
ALTER VIEW... 12
ANALYZE. 13
ARCHIVE LOG clause. 13
AUDIT (SQL Statements) 13
AUDIT (Schema Objects) 13
CLOSE (Embedded SQL) 13
COMMENT.. 14
COMMIT.. 14
COMMIT (Embedded SQL) 14
CONNECT (Embedded SQL) 14
CONSTRAINT clause. 14
CREATE CLUSTER.. 15
CREATE CONTROLFILE. 15
CREATE DATABASE. 16
CREATE DATABASE LINK.. 16
CREATE FUNCTION.. 16
CREATE INDEX.. 17
CREATE PACKAGE. 17
CREATE PACKAGE BODY.. 17
CREATE PROCEDURE. 17
CREATE PROFILE. 18
CREATE ROLE. 18
CREATE ROLLBACK SEGMENT.. 18
CREATE SCHEMA.. 18
CREATE SEQUENCE. 18
CREATE SNAPSHOT.. 19
CREATE SNAPSHOT LOG.. 19
CREATE SYNONYM... 19
CREATE TABLE. 20
CREATE TABLESPACE. 20
CREATE TRIGGER.. 20
CREATE USER.. 21
CREATE VIEW... 21
DEALLOCATE clause. 21
DECLARE CURSOR (Embedded SQL) 21
DECLARE DATABASE (Embedded SQL) 21
DECLARE STATEMENT (Embedded SQL) 21
DECLARE TABLE (Embedded SQL) 22
DELETE. 22
DELETE (Embedded SQL) 22
DESCRIBE (Embedded SQL) 22
DISABLE clause. 22
DROP clause. 22
DROP CLUSTER.. 22
DROP DATABASE LINK.. 22
DROP FUNCTION.. 23
DROP INDEX.. 23
DROP PACKAGE. 23
DROP PROCEDURE. 23
DROP PROFILE. 23
DROP ROLE. 23
DROP ROLLBACK SEGMENT.. 23
DROP SEQUENCE. 23
DROP SNAPSHOT.. 23
DROP SNAPSHOT LOG.. 23
DROP SYNONYM... 23
DROP TABLE. 23
DROP TABLESPACE. 23
DROP TRIGGER.. 23
DROP USER.. 24
DROP VIEW... 24
ENABLE clause. 24
EXECUTE (Prepared SQL Statements and PL/SQL Blocks) (Embedded SQL) 24
EXECUTE (Anonymous PL/SQL Blocks) (Embedded SQL) 24
EXECUTE IMMEDIATE (Embedded SQL) 24
EXPLAIN PLAN.. 24
FETCH (Embedded SQL) 24
Filespec. 25
GRANT (System Privileges and Roles) 25
GRANT (Object Privileges) 25
INSERT.. 25
INSERT (Embedded SQL) 25
LOCK TABLE. 26
NOAUDIT (SQL Statements) 26
NOAUDIT (Schema Objects) 26
OPEN (Embedded SQL) 26
PARALLEL clause. 26
PREPARE (Embedded SQL) 26
RECOVER clause. 27
RENAME. 27
REVOKE (System Privileges and Roles) 27
REVOKE (Object Privileges) 27
ROLLBACK.. 27
ROLLBACK (Embedded SQL) 27
SAVEPOINT.. 27
SAVEPOINT (Embedded SQL) 28
SELECT.. 28
SELECT (Embedded SQL) 29
SET ROLE. 30
SET TRANSACTION.. 30
STORAGE clause. 30
TRUNCATE. 30
TYPE (Embedded SQL) 30
UPDATE. 31
UPDATE (Embedded SQL) 31
VAR (Embedded SQL) 31
WHENEVER (Embedded SQL) 31