Oracle7 Server SQL Reference Manual

---

• Oracle7^(tm) _{Server SQL Reference}

• Preface
  • Audience
  • How this Manual is Organized

• Introduction
  • History of SQL
  • SQL Standards
  • How SQL Works
  • Embedded SQL
  • Lexical Conventions
  • Tools Support

• Elements of Oracle7 SQL
  • Database Objects
  • Object Names and Qualifiers
  • Referring to Objects and Parts
  • Literals
  • Text
  • Integer
  • Number
  • Datatypes
  • Nulls
  • Pseudocolumns
  • Comments

• Operators, Functions, Expressions, Conditions
  • Operators

• SQL Functions

• User Functions
• Format Models
• Expr
• Condition

• Commands
  • Summary of SQL Commands
  • ALLOCATE (Embedded SQL)
  • ALTER CLUSTER
  • ALTER DATABASE
  • ALTER FUNCTION
  • ALTER INDEX

• ALTER PACKAGE
• ALTER PROCEDURE
• ALTER PROFILE
• ALTER RESOURCE COST
• ALTER ROLE
• ALTER ROLLBACK SEGMENT
• ALTER SEQUENCE

• ALTER SESSION
• ALTER SNAPSHOT
• ALTER SNAPSHOT LOG
• ALTER SYSTEM

• ALTER TABLE
• ALTER TABLESPACE
• ALTER TRIGGER
• ALTER USER
• ALTER VIEW
• ANALYZE
• ARCHIVE LOG clause
• AUDIT (SQL Statements)
• AUDIT (Schema Objects)

• CLOSE (Embedded SQL)
• COMMENT
• COMMIT
• COMMIT (Embedded SQL)
• CONNECT (Embedded SQL)
• CONSTRAINT clause
• CREATE CLUSTER

• CREATE CONTROLFILE
• CREATE DATABASE
• CREATE DATABASE LINK
• CREATE FUNCTION
• CREATE INDEX
• CREATE PACKAGE
• CREATE PACKAGE BODY
• CREATE PROCEDURE
• CREATE PROFILE

• CREATE ROLE
• CREATE ROLLBACK SEGMENT
• CREATE SCHEMA
• CREATE SEQUENCE
• CREATE SNAPSHOT
• CREATE SNAPSHOT LOG
• CREATE SYNONYM
• CREATE TABLE
• CREATE TABLESPACE

• CREATE TRIGGER
• CREATE USER
• CREATE VIEW
• DEALLOCATE clause
• DECLARE CURSOR (Embedded SQL)
• DECLARE DATABASE (Embedded SQL)
• DECLARE STATEMENT (Embedded SQL)
• DECLARE TABLE (Embedded SQL)
• DELETE
• DELETE (Embedded SQL)
• DESCRIBE (Embedded SQL)
• DISABLE clause
• DROP clause
• DROP CLUSTER

• DROP DATABASE LINK
• DROP FUNCTION
• DROP INDEX
• DROP PACKAGE
• DROP PROCEDURE
• DROP PROFILE
• DROP ROLE
• DROP ROLLBACK SEGMENT
• DROP SEQUENCE
• DROP SNAPSHOT
• DROP SNAPSHOT LOG
• DROP SYNONYM
• DROP TABLE
• DROP TABLESPACE
• DROP TRIGGER
• DROP USER
• DROP VIEW
• ENABLE clause
• EXECUTE (Prepared SQL Statements and PL/SQL Blocks) (Embedded SQL)
• EXECUTE (Anonymous PL/SQL Blocks) (Embedded SQL)
• EXECUTE IMMEDIATE (Embedded SQL)
• EXPLAIN PLAN

• FETCH (Embedded SQL)
• Filespec
• GRANT (System Privileges and Roles)
• GRANT (Object Privileges)
• INSERT
• INSERT (Embedded SQL)
• LOCK TABLE
• NOAUDIT (SQL Statements)
• NOAUDIT (Schema Objects)
• OPEN (Embedded SQL)
• PARALLEL clause

• PREPARE (Embedded SQL)
• RECOVER clause
• RENAME
• REVOKE (System Privileges and Roles)
• REVOKE (Object Privileges)
• ROLLBACK
• ROLLBACK (Embedded SQL)
• SAVEPOINT
• SAVEPOINT (Embedded SQL)

• SELECT
• SELECT (Embedded SQL)
• SET ROLE

• SET TRANSACTION
• STORAGE clause
• TRUNCATE
• TYPE (Embedded SQL)
• UPDATE
• UPDATE (Embedded SQL)
• VAR (Embedded SQL)
• WHENEVER (Embedded SQL)

• Differences From Previous Versions
  • Differences Between Oracle7 Release 7.2 and Release 7.3
  • Differences Between Oracle7 Release 7.1 and Release 7.2
  • Differences Between Oracle7, Release 7.0 and Release 7.1
  • Differences Between Oracle Version 6 and Oracle7, Release 7.0
  • Reserved Words
  • Oracle Datatypes
  • New Commands
  • Existing Commands with New Functionality
  • SQL Functions
  • Format Models
  • Operators
  • Comments
  • Namespaces
  • Changes to the Optional Components of Oracle
  • Compatibility Modes

• Oracle and Standard SQL
  • Conformance with Standard SQL
  • Extensions to Standard SQL
  • FIPS Flagger

• Operating System-Specific Dependencies

---

Copyright © 1996 Oracle Corporation 500 Oracle Parkway, Redwood City, CA 94065