Enterprise Edition Home | Express Edition Home | Previous Page | Next Page   Overview of SQL Syntax > ANSI/ISO Compliance and Extensions >

Statements that are Extensions to the ANSI/ISO Standard

ALLOCATE COLLECTION
ALLOCATE ROW
ALTER ACCESS_METHOD
ALTER FRAGMENT
ALTER FUNCTION
ALTER INDEX
ALTER OPTICAL CLUSTER
ALTER PROCEDURE
ALTER ROUTINE
ALTER SEQUENCE

BEGIN WORK

CLOSE DATABASE
CREATE ACCESS_METHOD
CREATE AGGREGATE
CREATE CAST
CREATE DATABASE
CREATE DISTINCT TYPE
CREATE DUPLICATE
CREATE EXTERNAL TABLE
CREATE FUNCTION
CREATE FUNCTION FROM
CREATE INDEX
CREATE OPAQUE TYPE
CREATE OPCLASS
CREATE OPTICAL CLUSTER
CREATE PROCEDURE
CREATE PROCEDURE FROM
CREATE ROLE
CREATE ROUTINE FROM
CREATE ROW TYPE
CREATE SEQUENCE
CREATE SYNONYM
CREATE TRIGGER
CREATE XADATASOURCE
CREATE XADATASOURCE TYPE

DATABASE
DEALLOCATE COLLECTION
DEALLOCATE ROW
DROP ACCESS_METHOD
DROP AGGREGATE
DROP CAST
DROP DATABASE
DROP DUPLICATE DROP FUNCTION
DROP INDEX
DROP OPCLASS
DROP OPTICAL CLUSTER
DROP PROCEDURE
DROP ROLE
DROP ROUTINE
DROP ROW TYPE
DROP SEQUENCE
DROP SYNONYM
DROP TABLE
DROP TRIGGER
DROP TYPE
DROP VIEW
DROP XADATASOURCE
DROP XADATASOURCE TYPE

EXECUTE FUNCTION
EXECUTE PROCEDURE

FLUSH
FREE

GET DIAGNOSTICS
GRANT FRAGMENT

LOAD
LOCK TABLE

MERGE
MOVE

OUTPUT

PUT

RELEASE
RENAME COLUMN
RENAME DATABASE
RENAME INDEX
RENAME SEQUENCE
RENAME TABLE
RESERVE
REVOKE FRAGMENT

SAVE EXTERNAL DIRECTIVES
SET ALL_MUTABLES
SET AUTOFREE
SET COLLATION
SET Database Object Mode
SET DATASKIP
SET DEBUG FILE TO
SET Default Table Space
SET Default Table Type
SET DEFERRED_PREPARE
SET ENCRYPTION PASSWORD
SET ENVIRONMENT
SET EXPLAIN
SET ISOLATION
SET LOCK MODE
SET LOG
SET MOUNTING TIMEOUT
SET OPTIMIZATION
SET PDQPRIORITY
SET PLOAD FILE
SET Residency
SET ROLE
SET SCHEDULE LEVEL
SET STATEMENT CACHE
START VIOLATIONS TABLE
STOP VIOLATIONS TABLE

TRUNCATE

UNLOAD
UNLOCK TABLE
UPDATE STATISTICS

Enterprise Edition Home | Express Edition Home | [ Top of Page | Previous Page | Next Page | Contents | Index ]