CREATE FUNCTION
These commands have been
ALTER FUNCTION
added for stored functions.
DROP FUNCTION
CREATE PACKAGE
These commands have been
CREATE PACKAGE BODY
added for stored packages.
ALTER PACKAGE
DROP PACKAGE
CREATE PROCEDURE
These commands have been
ALTER PROCEDURE
added for stored procedures.
DROP PROCEDURE
CREATE TRIGGER
These commands have been
ALTER TRIGGER
added for database triggers.
DROP TRIGGER
ALTER VIEW
This command has been added to recompile views.
CREATE PROFILE
These commands have been
ALTER PROFILE
added for resource limits.
DROP PROFILE
ALTER RESOURCE COST
CREATE ROLE
These commands have been
ALTER ROLE
added for security.
DROP ROLE
SET ROLE
CREATE USER
DROP USER
CREATE SNAPSHOT
These commands have been
ALTER SNAPSHOT
added for. snapshots.
DROP SNAPSHOT
CREATE SNAPSHOT LOG
ALTER SNAPSHOT LOG
DROP SNAPSHOT LOG
ALTER SYSTEM
This command has been added to
perform various specialized
operations on an instance.
ANALYZE
This command has been added to
collect statistics for cost-based
optimization.
CREATE CONTROLFILE
This command has been added
for recovery.
CREATE SCHEMA
This command has been added to
added to issue multiple Data
Definition Language statements
in the same transaction.
TRUNCATE
This command has been added to
added to quickly remove all rows
from a table or cluster.
For complete information on each of these commands, see Chapter 4 "Commands" of this manual.
For a list of new embedded SQL commands for Oracle7, see Programmer's Guide to the Oracle Precompilers.