Home
Home
Help
Help
Contact us
Contact Us

SQL, PL/SQL, and SQL*Plus Syntax and Examples: O

Shortcuts to Items in the List

Statements, Keywords, Packages, and Functions

BASE Function: Definition
BASE Procedure: Definition
BASE64_DECODE Function: Definition
BASE64_ENCODE Function: Definition
BASEFONT Function: Definition
BASEFONT Procedure: Definition
BEGIN_DISCRETE_TRANSACTION Procedure: Definition
BEGIN_PREPARE Procedure: Definition
BEGIN_REQUEST Function: Definition
BEGIN_TABLE_REORGANIZATION Procedure: Definition
BEGIN_UPGRADE Procedure: Definition
BETWEEN Operator: Definition
BETWEEN predicate: Definition
BGSOUND Function: Definition
BGSOUND Procedure: Definition
BIG Function: Definition
BIG Procedure: Definition
BIND_AGENT Procedure: Definition
BIND_ARRAY Procedures: Definition
BIND_INOUT_VARIABLE Procedure: Definition
BIND_INOUT_VARIABLE_RAW Procedure: Definition
BIND_OUT_VARIABLE Procedure: Definition
BIND_OUT_VARIABLE_RAW Procedure: Definition
BIND_VARIABLE Procedure: Definition
BIND_VARIABLE Procedures: Definition
BIND_VARIABLES Function: Definition
BIND_VARIABLE_RAW Procedure: Definition
BIT_AND Function: Definition
BIT_COMPLEMENT Function: Definition
BIT_OR Function: Definition
BIT_XOR Function: Definition
BLAS_ASUM Functions: Definition
BLAS_AXPY Procedures: Definition
BLAS_COPY Procedures: Definition
BLAS_DOT Functions: Definition
BLAS_GBMV Procedures: Definition
BLAS_GEMM Procedures: Definition
BLAS_GEMV Procedures: Definition
BLAS_GER Procedures: Definition
BLAS_IAMAX Functions: Definition
BLAS_NRM2 Functions: Definition
BLAS_ROT Procedures: Definition
BLAS_ROTG Procedures: Definition
BLAS_SBMV Procedures: Definition
BLAS_SCAL Procedures: Definition
BLAS_SPMV Procedures: Definition
BLAS_SPR Procedures: Definition
BLAS_SPR2 Procedures: Definition
BLAS_SWAP Procedures: Definition
BLAS_SYMM Procedures: Definition
BLAS_SYMV Procedures: Definition
BLAS_SYR Procedures: Definition
BLAS_SYR2 Procedures: Definition
BLAS_SYR2K Procedures: Definition
BLAS_SYRK Procedures: Definition
BLAS_TBMV Procedures: Definition
BLAS_TBSV Procedures: Definition
BLAS_TPMV Procedures: Definition
BLAS_TPSV Procedures: Definition
BLAS_TRMM Procedures: Definition
BLAS_TRMV Procedures: Definition
BLAS_TRSM Procedures: Definition
BLAS_TRSV Procedures: Definition
BLOCKQUOTECLOSE Function: Definition
BLOCKQUOTECLOSE Procedure: Definition
BLOCKQUOTEOPEN Function: Definition
BLOCKQUOTEOPEN Procedure: Definition
BODYCLOSE Function: Definition
BODYCLOSE Procedure: Definition
BODYOPEN Function: Definition
BODYOPEN Procedure: Definition
BOLD Function: Definition
BOLD Procedure: Definition
BOOLEAN Expressions: Definition
BOOLEAN Literals: Definition
BR Function: Definition
BR Procedure: Definition
BREAK: Definition
BROKEN Procedure: Definition
BTITLE: Definition
BUILD Procedure: Definition
BUILD_CHAIN_ROWS_TABLE Procedure: Definition
BUILD_EXCEPTIONS_TABLE Procedure: Definition
BUILD_PART_INDEX Procedure: Definition
BUILD_SAFE_REWRITE_EQUIVALENCE Procedure: Definition
BYPASS Procedure: Definition
FCLOSE Procedure: Definition
FCLOSE_ALL Procedure: Definition
FCOPY Procedure: Definition
FEATURENAME Function: Definition
FETCH Statement: Definition
FETCH_ROW Function: Definition
FETCH_ROWS Function: Definition
FFLUSH Procedure: Definition
FGETATTR Procedure: Definition
FGETPOS Function: Definition
FILECLOSE Procedure: Definition
FILECLOSEALL Procedure: Definition
FILEEXISTS Function: Definition
FILEGETNAME Procedure: Definition
FILEISOPEN Function: Definition
FILEOPEN Procedure: Definition
FINDENTITY Function: Definition
FINDNOTATION Function: Definition
FIND_AFFECTED_TABLES Procedure: Definition
FINISH_CAPTURE Procedure: Definition
FINISH_REDEF_TABLE Procedure: Definition
FIX_CORRUPT_BLOCKS Procedure: Definition
FI_HORIZONTAL Function: Definition
FI_TRANSACTIONAL Function: Definition
FLOOR: Definition
FLUSH CACHE GROUP: Definition
FLUSH Procedure: Definition
FLUSHCACHE Procedure: Definition
FLUSHSTATS Function: Definition
FLUSH_DATABASE_MONITORING_INFO Procedure: Definition
FONTCLOSE Function: Definition
FONTCLOSE Procedure: Definition
FONTOPEN Function: Definition
FONTOPEN Procedure: Definition
FOPEN Function: Definition
FOPEN_NCHAR Function: Definition
FOR EACH ROW Triggers: Definition
FOR LOOP Index: Definition
FOR LOOP Statement: Definition
FORALL Statement: Definition
FORMAT Function: Definition
FORMAT_CALL_STACK Function: Definition
FORMAT_CELL Function: Definition
FORMAT_ERROR_BACKTRACE Function: Definition
FORMAT_ERROR_STACK Function: Definition
FORMAT_MESSAGE Function: Definition
FORMCHECKBOX Function: Definition
FORMCHECKBOX Procedure: Definition
FORMCLOSE Function: Definition
FORMCLOSE Procedure: Definition
FORMFILE Function: Definition
FORMFILE Procedure: Definition
FORMHIDDEN Function: Definition
FORMHIDDEN Procedure: Definition
FORMIMAGE Function: Definition
FORMIMAGE Procedure: Definition
FORMOPEN Function: Definition
FORMOPEN Procedure: Definition
FORMPASSWORD Function: Definition
FORMPASSWORD Procedure: Definition
FORMRADIO Function: Definition
FORMRADIO Procedure: Definition
FORMRESET Function: Definition
FORMRESET Procedure: Definition
FORMSELECTCLOSE Function: Definition
FORMSELECTCLOSE Procedure: Definition
FORMSELECTOPEN Function: Definition
FORMSELECTOPEN Procedure: Definition
FORMSELECTOPTION Function: Definition
FORMSELECTOPTION Procedure: Definition
FORMSUBMIT Function: Definition
FORMSUBMIT Procedure: Definition
FORMTEXT Function: Definition
FORMTEXT Procedure: Definition
FORMTEXTAREA Function: Definition
FORMTEXTAREA Procedure: Definition
FORMTEXTAREA2 Function: Definition
FORMTEXTAREA2 Procedure: Definition
FORMTEXTAREACLOSE Function: Definition
FORMTEXTAREACLOSE Procedure: Definition
FORMTEXTAREAOPEN Function: Definition
FORMTEXTAREAOPEN Procedure: Definition
FORMTEXTAREAOPEN2 Function: Definition
FORMTEXTAREAOPEN2 Procedure: Definition
FRAGMENT_DELETE Procedure: Definition
FRAGMENT_INSERT Procedures: Definition
FRAGMENT_MOVE Procedure: Definition
FRAGMENT_REPLACE Procedures: Definition
FRAME Function: Definition
FRAME Procedure: Definition
FRAMESETCLOSE Function: Definition
FRAMESETCLOSE Procedure: Definition
FRAMESETOPEN Function: Definition
FRAMESETOPEN Procedure: Definition
FREEDOCFRAG Procedure: Definition
FREEDOCUMENT Procedure: Definition
FREEELEMENT Procedure: Definition
FREENODE Procedure: Definition
FREENODELIST Procedure: Definition
FREEPARSER: Definition
FREEPROCESSOR Procedure: Definition
FREERESOURCE Procedure: Definition
FREESTYLESHEET Procedure: Definition
FREETEMPORARY Procedures: Definition
FREE_BLOCKS Procedure: Definition
FREE_UNUSED_USER_MEMORY Procedure: Definition
FREMOVE Procedure: Definition
FRENAME Procedure: Definition
FSEEK Procedure: Definition
IF Statement: Definition
IF THEN ELSE Statement: Definition
IF THEN ELSIF Statement: Definition
IF THEN Statement: Definition
IMG Function: Definition
IMG Procedure: Definition
IMG2 Function: Definition
IMG2 Procedure: Definition
IMPLEMENT_TASK Procedure: Definition
IMPLEMENT_TUNING_TASK Function: Definition
IMPORTNODE Function: Definition
IMPORT_AWR Function: Definition
IMPORT_COLUMN_STATS Procedure: Definition
IMPORT_DATABASE_PREFS Procedure: Definition
IMPORT_DATABASE_STATS Procedure: Definition
IMPORT_DICTIONARY_STATS Procedure: Definition
IMPORT_FIXED_OBJECTS_STATS Procedure: Definition
IMPORT_INDEX_STATS Procedure: Definition
IMPORT_MODEL Procedure: Definition
IMPORT_SCHEMA_PREFS Procedure: Definition
IMPORT_SCHEMA_STATS Procedure: Definition
IMPORT_SQLWKLD_SCHEMA Procedure: Definition
IMPORT_SQLWKLD_SQLCACHE Procedure: Definition
IMPORT_SQLWKLD_STS Procedure: Definition
IMPORT_SQLWKLD_SUMADV Procedure: Definition
IMPORT_SQLWKLD_USER Procedure: Definition
IMPORT_SQL_TESTCASE Procedures: Definition
IMPORT_SYSTEM_STATS Procedure: Definition
IMPORT_TABLE_PREFS Procedure: Definition
IMPORT_TABLE_STATS Procedure: Definition
IMPORT_XML Procedure: Definition
IN Mode: Definition
IN Operator: Definition
IN OUT Mode: Definition
INCIDENTID_2_SQL Procedure: Definition
INCLUDE_EXTRA_ATTRIBUTE Procedure: Definition
INDEX_PARAMETERS Procedure: Definition
INITFS Procedure: Definition
INITIALIZE Function: Definition
INITIALIZE Procedure: Definition
INITIALIZE_CUBE_UPGRADE Procedure: Definition
INITIALIZE_REPLAY Procedure: Definition
INITIATE_FS_FAILOVER Procedure: Definition
INIT_CLEANUP Procedure: Definition
INLINE Pragma: Definition
INPLACEEVOLVE Procedure: Definition
INPUT: Definition
INSERT: Definition
INSERT...SELECT: Definition
INSERTBEFORE Function: Definition
INSERTDATA Procedure: Definition
INSERTXML: Definition
INSERT_AUTOBIN_NUM_EQWIDTH Procedure: Definition
INSERT_BIN_CAT_FREQ Procedure: Definition
INSERT_BIN_NUM_EQWIDTH Procedure: Definition
INSERT_BIN_NUM_QTILE Procedure: Definition
INSERT_BIN_SUPER Procedure: Definition
INSERT_CLIP_TRIM_TAIL Procedure: Definition
INSERT_CLIP_WINSOR_TAIL Procedure: Definition
INSERT_FINDING_DIRECTIVE Procedure: Definition
INSERT_MISS_CAT_MODE Procedure: Definition
INSERT_MISS_NUM_MEAN Procedure: Definition
INSERT_NORM_LIN_MINMAX Procedure: Definition
INSERT_NORM_LIN_SCALE Procedure: Definition
INSERT_NORM_LIN_ZSCORE Procedure: Definition
INSERT_PARAMETER_DIRECTIVE Procedure: Definition
INSERT_SEGMENT_DIRECTIVE Procedure: Definition
INSERT_SQL_DIRECTIVE Procedure: Definition
INSTANCE Procedure: Definition
INSTANTIATE_TABLE Procedure: Definition
INSTEAD OF Triggers: Definition
INSTR: Definition
INSTR Functions: Definition
INTERNAL_VERSION_CHECK Function: Definition
INTERRUPT_ANALYSIS_TASK Procedure: Definition
INTERRUPT_DIAGNOSIS_TASK Procedure: Definition
INTERRUPT_TASK Procedure: Definition
INTERRUPT_TUNING_TASK Procedure: Definition
INTERVAL Procedure: Definition
INVALIDATE Procedure: Definition
INVALID_CURSOR Exception: Definition
IR ADTs: Definition
IS INFINITE predicate: Definition
IS NAN predicate: Definition
IS NULL predicate: Definition
IS [NOT] NULL Operator: Definition
ISDATAFILEDROPPABLE_NAME Procedure: Definition
ISFOLDER Function: Definition
ISFRAGMENT: Definition
ISINDEX Function: Definition
ISINDEX Procedure: Definition
ISNULL Function: Definition
ISNULL Functions: Definition
ISOPEN Function: Definition
ISOPEN Functions: Definition
ISSCHEMABASED: Definition
ISSCHEMAVALID: Definition
ISSCHEMAVALIDATED: Definition
ISTEMPORARY Functions: Definition
IS_APPLY_SERVER Function: Definition
IS_BIT_SET Function: Definition
IS_CLEANUP_INITIALIZED Function: Definition
IS_CLUSTER_DATABASE Function: Definition
IS_HIERARCHY_ENABLED Function: Definition
IS_LOCATOR Function: Definition
IS_MONITORING Function: Definition
IS_OPEN Function: Definition
IS_REPLAY_PAUSED Function: Definition
IS_ROLE_ENABLED Function: Definition
IS_SESSION_ALIVE Function: Definition
IS_TRIGGER_FIRE_ONCE Function: Definition
ITALIC Function: Definition
ITALIC Procedure: Definition
ITEM Functions: Definition
I_AM_A_REFRESH Function: Definition
OBJECT_DEPENDENT_SEGMENTS Function: Definition
OBJECT_GROWTH_TREND Function: Definition
OBJECT_VALUE Pseudocolumn: Definition
OER Breakpoints: Definition
OLD_CURRENT_SCHEMA Function: Definition
OLD_CURRENT_USER Function: Definition
OLISTCLOSE Function: Definition
OLISTCLOSE Procedure: Definition
OLISTOPEN Function: Definition
OLISTOPEN Procedure: Definition
ONLINE_INDEX_CLEAN Function: Definition
OPEN FOR Statement: Definition
OPEN Function: Definition
OPEN Procedures: Definition
OPEN Statement: Definition
OPENC Function: Definition
OPENW Function: Definition
OPEN_CONNECTION Function: Definition
OPEN_CONNECTION Functions: Definition
OPEN_CURSOR Function: Definition
OPEN_WINDOW Procedure: Definition
ORD_DICOM: Definition
ORD_DICOM_ADMIN: Definition
OUT Mode: Definition
OVERLAY Function: Definition
OVERRIDE_PRIORITY Procedures: Definition
OWA_CACHE: Definition
OWA_COOKIE: Definition
OWA_CUSTOM: Definition
OWA_IMAGE: Definition
OWA_OPT_LOCK: Definition
OWA_PATTERN: Definition
OWA_SEC: Definition
OWA_TEXT: Definition
OWA_UTIL: Definition