SQL and PL/SQL Syntax and Examples: A

Shortcuts to Items in the List

%

A

B

C

D

E

F

G

H

I

J

K

L

M

N

O

P

Q

R

S

T

U

V

W

X

Y

Z

Statements, Keywords, Packages, and Functions

ABORT Procedure: Definition , Search for examples

ABORTED_REQUEST_THRESHOLD Procedure: Definition , Search for examples

ABORT_GLOBAL_INSTANTIATION Procedure: Definition , Search for examples

ABORT_REDEF_TABLE Procedure: Definition , Search for examples

ABORT_SCHEMA_INSTANTIATION Procedure: Definition , Search for examples

ABORT_TABLE_INSTANTIATION Procedure: Definition , Search for examples

ABS: Definition , Search for examples

ACCEPT: Definition , Search for examples

ACCESSED GLOBALLY: Definition , Search for examples

ACCOUNT Clause: Definition , Search for examples

ACOS: Definition , Search for examples

ACTIVATE_SUBSCRIPTION Procedure: Definition , Search for examples

ACTIVE_INSTANCES Procedure: Definition , Search for examples

ACTIVE_INSTANCE_COUNT: Definition , Search for examples

ADD: Definition , Search for examples

ADD Clause: Definition , Search for examples

ADD Procedure: Definition , Search for examples

ADD | DROP: Definition , Search for examples

ADD_ALIAS_TO_LDAP Procedure: Definition , Search for examples

ADD_COOKIES Procedure: Definition , Search for examples

ADD_DEFAULT_DEST Procedure: Definition , Search for examples

ADD_FILTER_ITEM Procedure: Definition , Search for examples

ADD_GLOBAL_PROPAGATION_RULES Procedure: Definition , Search for examples

ADD_GLOBAL_RULES Procedure: Definition , Search for examples

ADD_GROUPED_COLUMN Procedure: Definition , Search for examples

ADD_GROUPED_POLICY Procedure: Definition , Search for examples

ADD_LOGFILE Procedure: Definition , Search for examples

ADD_MASTER_DATABASE Procedure: Definition , Search for examples

ADD_MONTHS: Definition , Search for examples

ADD_NEW_MASTERS Procedure: Definition , Search for examples

ADD_POLICY Procedure: Definition , Search for examples

ADD_POLICY_CONTEXT Procedure: Definition , Search for examples

ADD_RULE Procedure: Definition , Search for examples

ADD_SCHEMA_PROPAGATION_RULES Procedure: Definition , Search for examples

ADD_SCHEMA_RULES Procedure: Definition , Search for examples

ADD_SITE_PRIORITY_SITE Procedure: Definition , Search for examples

ADD_SUBSCRIBER Procedure: Definition , Search for examples

ADD_SUBSET_RULES Procedure: Definition , Search for examples

ADD_TABLE_PROPAGATION_RULES Procedure: Definition , Search for examples

ADD_TABLE_RULES Procedure: Definition , Search for examples

ADD_TRANSFORM Procedure: Definition , Search for examples

ADMIN_TABLES Procedure: Definition , Search for examples

ADVISE Clause: Definition , Search for examples

ADVISE_COMMIT Procedure: Definition , Search for examples

ADVISE_NOTHING Procedure: Definition , Search for examples

ADVISE_ROLLBACK Procedure: Definition , Search for examples

AFTER: Definition , Search for examples

AGENT Clause: Definition , Search for examples

AGGREGATE USING Clause: Definition , Search for examples

ALL: Definition , Search for examples

ALL Clause: Definition , Search for examples

ALL TRIGGERS: Definition , Search for examples

ALLOCATE_UNIQUE Procedure: Definition , Search for examples

ALLOW_ALL Procedure: Definition , Search for examples

ALLOW_SERVER Procedure: Definition , Search for examples

ALL_XML_SCHEMAS: Definition , Search for examples

ALL_XML_TABLES: Definition , Search for examples

ALL_XML_TAB_COLS: Definition , Search for examples

ALL_XML_VIEWS: Definition , Search for examples

ALL_XML_VIEW_COLS: Definition , Search for examples

ALTER CLUSTER: Definition , Search for examples

ALTER DATABASE: Definition , Search for examples

ALTER DIMENSION: Definition , Search for examples

ALTER FUNCTION: Definition , Search for examples

ALTER INDEX: Definition , Search for examples

ALTER INDEXTYPE: Definition , Search for examples

ALTER JAVA: Definition , Search for examples

ALTER MATERIALIZED VIEW: Definition , Search for examples

ALTER MATERIALIZED VIEW LOG: Definition , Search for examples

ALTER OPERATOR: Definition , Search for examples

ALTER OUTLINE: Definition , Search for examples

ALTER PACKAGE: Definition , Search for examples

ALTER PROCEDURE: Definition , Search for examples

ALTER PROFILE: Definition , Search for examples

ALTER RESOURCE COST: Definition , Search for examples

ALTER ROLE: Definition , Search for examples

ALTER ROLLBACK SEGMENT: Definition , Search for examples

ALTER SEQUENCE: Definition , Search for examples

ALTER SESSION: Definition , Search for examples

ALTER SYSTEM: Definition , Search for examples

ALTER TABLE: Definition , Search for examples

ALTER TABLESPACE: Definition , Search for examples

ALTER TRIGGER: Definition , Search for examples

ALTER TYPE: Definition , Search for examples

ALTER USER: Definition , Search for examples

ALTER VIEW: Definition , Search for examples

ALTER_AGENT Procedure: Definition , Search for examples

ALTER_APPLY Procedure: Definition , Search for examples

ALTER_AQ_AGENT Procedure: Definition , Search for examples

ALTER_CAPTURE Procedure: Definition , Search for examples

ALTER_CATCHUP_PARAMETERS Procedure: Definition , Search for examples

ALTER_CHANGE_TABLE Procedure: Definition , Search for examples

ALTER_COMPILE Procedure: Definition , Search for examples

ALTER_DATABASE_TABLE_MONITORING Procedure: Definition , Search for examples

ALTER_MASTER_PROPAGATION Procedure: Definition , Search for examples

ALTER_MASTER_REPOBJECT Procedure: Definition , Search for examples

ALTER_MSGSYSTEM_LINK Procedure: Definition , Search for examples

ALTER_MVIEW_PROPAGATION Procedure: Definition , Search for examples

ALTER_PRIORITY Procedure: Definition , Search for examples

ALTER_PROPAGATION Procedure: Definition , Search for examples

ALTER_PROPAGATION_SCHEDULE Procedure: Definition , Search for examples

ALTER_QUEUE Procedure: Definition , Search for examples

ALTER_QUEUE_TABLE Procedure: Definition , Search for examples

ALTER_REFRESH_TEMPLATE Procedure: Definition , Search for examples

ALTER_RULE Procedure: Definition , Search for examples

ALTER_SCHEMA_TABLE_MONITORING Procedure: Definition , Search for examples

ALTER_SITE_PRIORITY Procedure: Definition , Search for examples

ALTER_SITE_PRIORITY_SITE Procedure: Definition , Search for examples

ALTER_SUBSCRIBER Procedure: Definition , Search for examples

ALTER_TABLE_NOT_REFERENCEABLE Procedure: Definition , Search for examples

ALTER_TABLE_REFERENCEABLE Procedure: Definition , Search for examples

ALTER_TEMPLATE_OBJECT Procedure: Definition , Search for examples

ALTER_TEMPLATE_PARM Procedure: Definition , Search for examples

ALTER_USER_AUTHORIZATION Procedure: Definition , Search for examples

ALTER_USER_PARM_VALUE Procedure: Definition , Search for examples

ANALYZE: Definition , Search for examples

ANALYZE_DATABASE Procedure: Definition , Search for examples

ANALYZE_OBJECT Procedure: Definition , Search for examples

ANALYZE_PART_OBJECT Procedure: Definition , Search for examples

ANALYZE_SCHEMA Procedure: Definition , Search for examples

AND DATAFILES: Definition , Search for examples

ANSI Standards: Definition , Search for examples

ANYDATA TYPE: Definition , Search for examples

ANYDATASET TYPE: Definition , Search for examples

ANYTYPE TYPE: Definition , Search for examples

APPEND: Definition , Search for examples

APPEND Procedure: Definition , Search for examples

APPLY_SET Procedure: Definition , Search for examples

APPLY_UNSET Procedure: Definition , Search for examples

AQ PL/SQL Callback: Definition , Search for examples

AQ$_AGENT Type: Definition , Search for examples

AQ$_AGENT_LIST_T Type: Definition , Search for examples

AQ$_DESCRIPTOR Type: Definition , Search for examples

AQ$_POST_INFO Type: Definition , Search for examples

AQ$_POST_INFO_LIST Type: Definition , Search for examples

AQ$_RECIPIENT_LIST_T Type: Definition , Search for examples

AQ$_REG_INFO Type: Definition , Search for examples

AQ$_REG_INFO_LIST Type: Definition , Search for examples

AQ$_SUBSCRIBER_LIST_T Type: Definition , Search for examples

AQ_TM_PROCESSES: Definition , Search for examples

ARCHIVE LOG: Definition , Search for examples

ARCHIVELOG Mode: Definition , Search for examples

ARCHIVELOG | NOARCHIVELOG: Definition , Search for examples

ARCHIVE_LAG_TARGET: Definition , Search for examples

AS source_text: Definition , Search for examples

AS subquery: Definition , Search for examples

ASCII: Definition , Search for examples

ASCIISTR: Definition , Search for examples

ASIN: Definition , Search for examples

ASSOCIATE STATISTICS: Definition , Search for examples

ATAN: Definition , Search for examples

ATAN2: Definition , Search for examples

ATTACH_SESSION Procedure: Definition , Search for examples

ATTRIBUTE: Definition , Search for examples

AUDIT: Definition , Search for examples

AUDIT_FILE_DEST: Definition , Search for examples

AUDIT_SYS_OPERATIONS: Definition , Search for examples

AUDIT_TRAIL: Definition , Search for examples

AUTHID: Definition , Search for examples

AUTHID Clause: Definition , Search for examples

AUTONOMOUS_TRANSACTION Pragma: Definition , Search for examples

AVG: Definition , Search for examples

Copyright © 2002 Oracle Corporation
All Rights Reserved.