Commands In Oracle

ANALYZE Statement

Now superceeded by GATHER_SCHEMA_STATS.

AUDIT Statement

Audit an SQL statement or access to a specific database object.

CALL

Execute a procedure or function from within SQL (may be used for both stored rocedures/packages and standalone routines).

CLUSTER

CREATE CLUSTER

ALTER CLUSTER

DROP CLUSTER

COMMENT

Add a comment to the data dictionary.

COMMIT

Save changes (transactional).
Syntax:

Syntax:

   COMMIT [WORK] [COMMENT 'comment_text']
   COMMIT [WORK] [FORCE 'force_text' [,int] ]

CONNECT

Start a user session.

TRUNCATE

Remove ALL rows from a table or cluster.

TRUNCATE TABLE table_name
Bibliography
Unless otherwise stated, the content of this page is licensed under Creative Commons Attribution-Share Alike 2.5 License.