Oracle7 Server SQL Reference

Contents Index Home Previous Next

New Commands

These commands are new to the SQL language for Oracle7.

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.


Contents Index Home Previous Next