Титульная страница
ISO 9000 ISO 14000
GMP Consulting
 

 

 

 

 

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

 


 

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)

 

 
Rambler's Top100