Oracle7 Server SQL Reference

• 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