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

O: Definition, Search for examples
OBJECT Types: Definition, Search for examples
OBJECT Types: Definition, Search for examples
OBJECT Types: Definition, Search for examples
OBJECT Types: Definition, Search for examples
OBJECT Types: Definition, Search for examples
OBJECT Types: Definition, Search for examples
OBJECT_CLASS: Definition, Search for examples
OBJECT_DEPENDENT_SEGMENTS Function: Definition, Search for examples
OBJECT_GRANT: Definition, Search for examples
OBJECT_GROWTH_TREND Function: Definition, Search for examples
OBJECT_NAME: Definition, Search for examples
OBJECT_NODE_PLUS_EXP: Definition, Search for examples
OBJECT_SCHEMA: Definition, Search for examples
OBJECT_TYPE_EVENT_CLASS: Definition, Search for examples
OBJECT_TYPE_FILE: Definition, Search for examples
OBJECT_TYPE_SERVICE: Definition, Search for examples
OBJECT_TYPE_SESSION: Definition, Search for examples
OBJECT_TYPE_SYSTEM: Definition, Search for examples
OBJECT_TYPE_TABLESPACE: Definition, Search for examples
OBJECT_TYPE_WRCLIENT: Definition, Search for examples
OBJECT_VALUE Pseudocolumn: Definition, Search for examples
OCLT_MAX_BUFFER: Definition, Search for examples
OCLT_SENSITIVITY: Definition, Search for examples
ODMS_ITEM_ID_COLUMN_NAME: Definition, Search for examples
ODMS_ITEM_VALUE_COLUMN_NAME: Definition, Search for examples
ODMS_MISSING_VALUE_TREATMENT: Definition, Search for examples
ODMS_ROW_WEIGHT_COLUMN_NAME: Definition, Search for examples
OER-6516: Definition, Search for examples
OFF: Definition, Search for examples
OFFSET Rules : Definition, Search for examples
OID: Definition, Search for examples
OLD_CURRENT_SCHEMA Function: Definition, Search for examples
OLD_CURRENT_USER Function: Definition, Search for examples
OLISTCLOSE Function: Definition, Search for examples
OLISTCLOSE Procedure: Definition, Search for examples
OLISTOPEN Function: Definition, Search for examples
OLISTOPEN Procedure: Definition, Search for examples
ON: Definition, Search for examples
ONLINE_INDEX_CLEAN Function: Definition, Search for examples
OP_ACL: Definition, Search for examples
OP_CREATE: Definition, Search for examples
OP_CREATEFILE: Definition, Search for examples
OP_CREATELINK: Definition, Search for examples
OP_CREATEREFERENCE: Definition, Search for examples
OP_DELETE: Definition, Search for examples
OP_DELETEDIRECTORY: Definition, Search for examples
OP_DELETEFILE: Definition, Search for examples
OP_GET: Definition, Search for examples
OP_LIST: Definition, Search for examples
OP_LOCK: Definition, Search for examples
OP_PURGE: Definition, Search for examples
OP_PUT: Definition, Search for examples
OP_READ: Definition, Search for examples
OP_RENAME: Definition, Search for examples
OP_RENAMEFROM: Definition, Search for examples
OP_RENAMETO: Definition, Search for examples
OP_RESTORE: Definition, Search for examples
OP_SEARCH: Definition, Search for examples
OP_SETPATH: Definition, Search for examples
OP_STORE: Definition, Search for examples
OP_UNLOCK: Definition, Search for examples
OP_WRITE: Definition, Search for examples
OPEN Function: Definition, Search for examples
OPEN Function: Definition, Search for examples
OPEN Procedures: Definition, Search for examples
OPEN Statement: Definition, Search for examples
OPEN_CONNECTION Function: Definition, Search for examples
OPEN_CONNECTION Functions: Definition, Search for examples
OPEN_CURSOR Function: Definition, Search for examples
OPEN_CURSOR Function: Definition, Search for examples
OPEN_CURSORS_CURRENT: Definition, Search for examples
OPEN_CURSORS_SEC: Definition, Search for examples
OPEN_CURSORS_TXN: Definition, Search for examples
OPEN_TOOMANY: Definition, Search for examples
OPEN_WINDOW Procedure: Definition, Search for examples
OPENC Function: Definition, Search for examples
OPENW Function: Definition, Search for examples
OPERATION: Definition, Search for examples
OPERATION_FAILED: Definition, Search for examples
OPERATOR: Definition, Search for examples
OPERATOR_CONTAINS: Definition, Search for examples
OPERATOR_DO_NOT_CHECK: Definition, Search for examples
OPERATOR_EQ: Definition, Search for examples
OPERATOR_GE: Definition, Search for examples
OPERATOR_GT: Definition, Search for examples
OPERATOR_LE: Definition, Search for examples
OPERATOR_LT: Definition, Search for examples
OPERATOR_NE: Definition, Search for examples
OPT_COMPRESS: Definition, Search for examples
OPT_CONTENT_ID: Definition, Search for examples
OPT_DEDUPLICATE: Definition, Search for examples
OPT_ENCRYPT: Definition, Search for examples
OPT_HASH_TYPE: Definition, Search for examples
OPT_HASH_VALUE: Definition, Search for examples
OPT_LOCK_COUNT: Definition, Search for examples
OPT_LOCK_DATA: Definition, Search for examples
OPT_LOCK_STATUS: Definition, Search for examples
OPT_LOCKER: Definition, Search for examples
OPT_VERSION: Definition, Search for examples
OPT_VERSION_PATH: Definition, Search for examples
OPTIMIZATION: Definition, Search for examples
OR: Definition, Search for examples
ORA-00904: Definition, Search for examples
ORA-00931: Definition, Search for examples
ORA-01031: Definition, Search for examples
ORA-01280: Definition, Search for examples
ORA-01281: Definition, Search for examples
ORA-01282: Definition, Search for examples
ORA-01283: Definition, Search for examples
ORA-01284: Definition, Search for examples
ORA-01285: Definition, Search for examples
ORA-01287: Definition, Search for examples
ORA-01289: Definition, Search for examples
ORA-01290: Definition, Search for examples
ORA-01291: Definition, Search for examples
ORA-01292: Definition, Search for examples
ORA-01293: Definition, Search for examples
ORA-01294: Definition, Search for examples
ORA-01295: Definition, Search for examples
ORA-01296: Definition, Search for examples
ORA-01297: Definition, Search for examples
ORA-01299: Definition, Search for examples
ORA-01300: Definition, Search for examples
ORA-01307: Definition, Search for examples
ORA-01309: Definition, Search for examples
ORA-01323: Definition, Search for examples
ORA-01324: Definition, Search for examples
ORA-01555: Definition, Search for examples
ORA-06502: Definition, Search for examples
ORA-08180: Definition, Search for examples
ORA-08181: Definition, Search for examples
ORA-08182: Definition, Search for examples
ORA-08183: Definition, Search for examples
ORA-08184: Definition, Search for examples
ORA-08185: Definition, Search for examples
ORA-1403: Definition, Search for examples
ORA-16103: Definition, Search for examples
ORA-16104: Definition, Search for examples
ORA-16109: Definition, Search for examples
ORA-16203: Definition, Search for examples
ORA-16236: Definition, Search for examples
ORA-16276: Definition, Search for examples
ORA-16277: Definition, Search for examples
ORA-16278: Definition, Search for examples
ORA-20000: Definition, Search for examples
ORA-20000: Definition, Search for examples
ORA-20000: Definition, Search for examples
ORA-20000:: Definition, Search for examples
ORA-20001: Definition, Search for examples
ORA-20001: Definition, Search for examples
ORA-20001: Definition, Search for examples
ORA-20001: Definition, Search for examples
ORA-20001:: Definition, Search for examples
ORA-20002: Definition, Search for examples
ORA-20002: Definition, Search for examples
ORA-20002: Definition, Search for examples
ORA-20002: Definition, Search for examples
ORA-20002:: Definition, Search for examples
ORA-20003: Definition, Search for examples
ORA-20004: Definition, Search for examples
ORA-20111: Definition, Search for examples
ORA-20112: Definition, Search for examples
ORA-20113: Definition, Search for examples
ORA-23321:: Definition, Search for examples
ORA-23322: Definition, Search for examples
ORA-23322:: Definition, Search for examples
ORA-24190: Definition, Search for examples
ORA-24191: Definition, Search for examples
ORA-24192: Definition, Search for examples
ORA-24193: Definition, Search for examples
ORA-24194: Definition, Search for examples
ORA-24195: Definition, Search for examples
ORA-24196: Definition, Search for examples
ORA-24197: Definition, Search for examples
ORA-24198: Definition, Search for examples
ORA-24199: Definition, Search for examples
ORA-24234: Definition, Search for examples
ORA-24235: Definition, Search for examples
ORA-24236: Definition, Search for examples
ORA-24247: Definition, Search for examples
ORA-28550: Definition, Search for examples
ORA-28551: Definition, Search for examples
ORA-28552: Definition, Search for examples
ORA-28553: Definition, Search for examples
ORA-28554: Definition, Search for examples
ORA-28555: Definition, Search for examples
ORA-29257: Definition, Search for examples
ORA-30388: Definition, Search for examples
ORA-30391: Definition, Search for examples
ORA-30392: Definition, Search for examples
ORA-30393: Definition, Search for examples
ORA-30396: Definition, Search for examples
ORA-31001: Definition, Search for examples
ORA-31401: Definition, Search for examples
ORA-31402: Definition, Search for examples
ORA-31403: Definition, Search for examples
ORA-31406: Definition, Search for examples
ORA-31407: Definition, Search for examples
ORA-31408: Definition, Search for examples
ORA-31409: Definition, Search for examples
ORA-31409: Definition, Search for examples
ORA-31410: Definition, Search for examples
ORA-31411: Definition, Search for examples
ORA-31415: Definition, Search for examples
ORA-31415: Definition, Search for examples
ORA-31416: Definition, Search for examples
ORA-31417: Definition, Search for examples
ORA-31418: Definition, Search for examples
ORA-31419: Definition, Search for examples
ORA-31420: Definition, Search for examples
ORA-31421: Definition, Search for examples
ORA-31422: Definition, Search for examples
ORA-31423: Definition, Search for examples
ORA-31424: Definition, Search for examples
ORA-31425: Definition, Search for examples
ORA-31425: Definition, Search for examples
ORA-31426: Definition, Search for examples
ORA-31427: Definition, Search for examples
ORA-31428: Definition, Search for examples
ORA-31429: Definition, Search for examples
ORA-31432: Definition, Search for examples
ORA-31432: Definition, Search for examples
ORA-31436: Definition, Search for examples
ORA-31437: Definition, Search for examples
ORA-31438: Definition, Search for examples
ORA-31441: Definition, Search for examples
ORA-31445: Definition, Search for examples
ORA-31447: Definition, Search for examples
ORA-31449: Definition, Search for examples
ORA-31450: Definition, Search for examples
ORA-31451: Definition, Search for examples
ORA-31452: Definition, Search for examples
ORA-31454: Definition, Search for examples
ORA-31455: Definition, Search for examples
ORA-31456: Definition, Search for examples
ORA-31457: Definition, Search for examples
ORA-31459: Definition, Search for examples
ORA-31466: Definition, Search for examples
ORA-31467: Definition, Search for examples
ORA-31468: Definition, Search for examples
ORA-31469: Definition, Search for examples
ORA-31469: Definition, Search for examples
ORA-31471: Definition, Search for examples
ORA-31480: Definition, Search for examples
ORA-31481: Definition, Search for examples
ORA-31482: Definition, Search for examples
ORA-31483: Definition, Search for examples
ORA-31484: Definition, Search for examples
ORA-31485: Definition, Search for examples
ORA-31487: Definition, Search for examples
ORA-31488: Definition, Search for examples
ORA-31497: Definition, Search for examples
ORA-31498: Definition, Search for examples
ORA-31499: Definition, Search for examples
ORA-31501: Definition, Search for examples
ORA-31503: Definition, Search for examples
ORA-31504: Definition, Search for examples
ORA-31505: Definition, Search for examples
ORA-31506: Definition, Search for examples
ORA-31507: Definition, Search for examples
ORA-31508: Definition, Search for examples
ORA-31508: Definition, Search for examples
ORA-31509: Definition, Search for examples
ORA-31510: Definition, Search for examples
ORA-31511: Definition, Search for examples
ORA-31514: Definition, Search for examples
ORA-31514: Definition, Search for examples
ORA-31532: Definition, Search for examples
ORA-31534: Definition, Search for examples
ORA-31535: Definition, Search for examples
ORA-38817: Definition, Search for examples
ORA-55602: Definition, Search for examples
ORA-55634: Definition, Search for examples
ORA-55636: Definition, Search for examples
ORA-56500: Definition, Search for examples
ORA-56501: Definition, Search for examples
ORA-56504: Definition, Search for examples
ORA-56505: Definition, Search for examples
ORA-56506: Definition, Search for examples
ORA-56507: Definition, Search for examples
ORA-942: Definition, Search for examples
ORA_EDITION: Definition, Search for examples
ORA_NLS10: Definition, Search for examples
ORACLE_FUNCTION: Definition, Search for examples
ORACLE_HOME: Definition, Search for examples
ORACLE_PATH: Definition, Search for examples
ORACLE_SID: Definition, Search for examples
ORACLE_TO_IANA: Definition, Search for examples
ORACLE_USER: Definition, Search for examples
ORD_DICOM: Definition, Search for examples
ORD_DICOM_ADMIN: Definition, Search for examples
ORDER: Definition, Search for examples
ORDER_LIST: Definition, Search for examples
ORU-10027: Definition, Search for examples
ORU-10027:: Definition, Search for examples
ORU-10028: Definition, Search for examples
ORU-10028:: Definition, Search for examples
OS_FILE_MAX_AGE: Definition, Search for examples
OS_FILE_MAX_SIZE: Definition, Search for examples
OS_PROCESS: Definition, Search for examples
OS_SCHED_CPU__WAIT_TIME: Definition, Search for examples
OS_SCHED_CPU_WAIT_SCT: Definition, Search for examples
OS_SERVICE_WAIT_SCT: Definition, Search for examples
OS_SERVICE_WAIT_TIME: Definition, Search for examples
OS_USER: Definition, Search for examples
OTHER_PLUS_EXP: Definition, Search for examples
OTHER_TAG_PLUS_EXP: Definition, Search for examples
OTHER_WAIT_SCT: Definition, Search for examples
OTHER_WAIT_TIME: Definition, Search for examples
OTHERS: Definition, Search for examples
OUT: Definition, Search for examples
OUT: Definition, Search for examples
OUTBOUND_PROPAGATION Jobs: Definition, Search for examples
OUTBOUND_PROPAGATION Subscribers: Definition, Search for examples
OUTBOUND_PROPAGATION: Definition, Search for examples
OUTLINE: Definition, Search for examples
OUTPUT: Definition, Search for examples
OVERLAY Function: Definition, Search for examples
OVERRIDE_PRIORITY Procedures: Definition, Search for examples
OVERRIDING: Definition, Search for examples
OWA_CACHE: Definition, Search for examples
OWA_COOKIE: Definition, Search for examples
OWA_CUSTOM: Definition, Search for examples
OWA_IMAGE: Definition, Search for examples
OWA_OPT_LOCK: Definition, Search for examples
OWA_PATTERN: Definition, Search for examples
OWA_SEC: Definition, Search for examples
OWA_TEXT: Definition, Search for examples
OWA_UTIL: Definition, Search for examples
OWNER: Definition, Search for examples
OWNER: Definition, Search for examples
OWNER: Definition, Search for examples
OWNER: Definition, Search for examples