Home
Home
Customize
Customize
Help
Help
Contact us
Contact Us

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

Shortcuts to Items in the List

Statements, Keywords, Packages, and Functions

ADD_GLOBAL_PROPAGATION_RULES Procedure: Definition
ADD_GLOBAL_RULES Procedure: Definition
ADD_SCHEMA_PROPAGATION_RULES Procedure: Definition
ADD_SCHEMA_RULES Procedure: Definition
ADD_SUBSET_PROPAGATION_RULES Procedure: Definition
ADD_SUBSET_RULES Procedure: Definition
ADD_TABLE_PROPAGATION_RULES Procedure: Definition
ADD_TABLE_RULES Procedure: Definition
ALL_CAPTURE_PREPARED_DATABASE: Definition
ALL_CAPTURE_PREPARED_SCHEMAS: Definition
ALL_CAPTURE_PREPARED_TABLES: Definition
ALL_MVIEWS: Definition
ALTER MATERIALIZED VIEW: Definition
ALTER MATERIALIZED VIEW LOG: Definition
ALTER_APPLY Procedure: Definition
COMPARE_OLD_VALUES Procedure: Definition
CREATE CLUSTER: Definition
CREATE MATERIALIZED VIEW: Definition
CREATE MATERIALIZED VIEW LOG: Definition
CREATE TABLE: Definition
CREATE_APPLY Procedure: Definition
CREATE_OBJECT_DEPENDENCY Procedure: Definition
DBA_CAPTURE_PREPARED_DATABASE: Definition
DBA_CAPTURE_PREPARED_SCHEMAS: Definition
DBA_CAPTURE_PREPARED_TABLES: Definition
DBA_FEATURE_USAGE_STATISTICS: Definition
DBA_REGISTERED_MVIEW_GROUPS: Definition
DBMS_APPLY_ADM: Definition
DBMS_CAPTURE_ADM: Definition
DBMS_DEFER: Definition
DBMS_DEFER_QUERY: Definition
DBMS_DEFER_SYS: Definition
DBMS_DEFER_SYS: Definition
DBMS_OFFLINE_OG: Definition
DBMS_OFFLINE_OG: Definition
DBMS_PROPAGATION_ADM: Definition
DBMS_RECTIFIER_DIFF: Definition
DBMS_REFRESH: Definition
DBMS_REPCAT: Definition
DBMS_REPCAT: Definition
DBMS_REPCAT_ADMIN: Definition
DBMS_REPCAT_ADMIN: Definition
DBMS_REPCAT_INSTANTIATE: Definition
DBMS_REPCAT_RGT: Definition
DBMS_REPUTIL: Definition
DBMS_REPUTIL: Definition
DBMS_STREAMS_ADM: Definition
DROP MATERIALIZED VIEW: Definition
DROP MATERIALIZED VIEW LOG: Definition
DROP_OBJECT_DEPENDENCY: Definition
GET_SCN_MAPPING Procedure: Definition
GET_TAG Function: Definition
JOB_QUEUE_PROCESSES: Definition
LCR$_ROW_RECORD Type: Definition
MAINTAIN_GLOBAL Procedure: Definition
MAINTAIN_SCHEMAS Procedure: Definition
MAINTAIN_SIMPLE_TABLESPACE Procedure: Definition
MAINTAIN_SIMPLE_TTS Procedure: Definition
MAINTAIN_TABLES Procedure: Definition
MAINTAIN_TABLESPACES Procedure: Definition
MAINTAIN_TTS Procedure: Definition
PARALLEL_EXECUTION_MESSAGE_SIZE: Definition
POST_INSTANTIATION_SETUP Procedure: Definition
PREPARE_GLOBAL_INSTANTIATION Procedure: Definition
PREPARE_SCHEMA_INSTANTIATION Procedure: Definition
PREPARE_TABLE_INSTANTIATION Procedure: Definition
PRE_INSTANTIATION_SETUP Procedure: Definition
RAISE Statement: Definition
RANDOM Procedure: Definition
RANDOMBYTES Function: Definition
RANDOMINTEGER Function: Definition
RANDOMNUMBER Function: Definition
RANK: Definition
RANK_APPLY Procedure: Definition
RATIO_TO_REPORT: Definition
RAW Datatype: Definition
RAWTOHEX: Definition
RAWTONHEX: Definition
RAW_TO_CHAR Functions: Definition
RAW_TO_NCHAR Functions: Definition
RCPT Function: Definition
RE$ATTRIBUTE_VALUE Type: Definition
RE$ATTRIBUTE_VALUE_LIST Type: Definition
RE$COLUMN_VALUE Type: Definition
RE$COLUMN_VALUE_LIST Type: Definition
RE$NAME_ARRAY Type: Definition
RE$NV_ARRAY Type: Definition
RE$NV_LIST Type: Definition
RE$NV_NODE Type: Definition
RE$RULE_HIT Type: Definition
RE$RULE_HIT_LIST Type: Definition
RE$TABLE_ALIAS Type: Definition
RE$TABLE_ALIAS_LIST Type: Definition
RE$TABLE_VALUE Type: Definition
RE$TABLE_VALUE_LIST Type: Definition
RE$VARIABLE_TYPE Type: Definition
RE$VARIABLE_TYPE_LIST Type: Definition
RE$VARIABLE_VALUE Type: Definition
RE$VARIABLE_VALUE_LIST Type: Definition
READ Procedures: Definition
READ2CLOB Function: Definition
READ_CLIENT_INFO Procedure: Definition
READ_LINE Function: Definition
READ_LINE Procedure: Definition
READ_MODULE Procedure: Definition
READ_ONLY Procedure: Definition
READ_RAW Function: Definition
READ_RAW Procedure: Definition
READ_TEXT Function: Definition
READ_TEXT Procedure: Definition
READ_WRITE Procedure: Definition
REBUILD Procedure: Definition
REBUILDHIERARCHICALINDEX Procedure: Definition
REBUILD_FREELISTS Procedure: Definition
RECEIVE_MESSAGE Function: Definition
RECOMMEND_MVIEW_STRATEGY Procedure: Definition
RECOMP_PARALLEL Procedure: Definition
RECOMP_SERIAL Procedure: Definition
RECOVER: Definition
RECOVER_OPERATION Procedure: Definition
REDIRECT_URL Procedure: Definition
REF: Definition
REF Datatypes: Definition
REFRESH Procedures: Definition
REFRESH_ALL_MVIEWS Procedure: Definition
REFRESH_DEPENDENT Procedures: Definition
REFRESH_GROUPED_POLICY Procedure: Definition
REFRESH_POLICY Procedure: Definition
REFRESH_PRIVATE_OUTLINE Procedure: Definition
REFTOHEX: Definition
REGEXP_INSTR: Definition
REGEXP_LIKE Condition: Definition
REGEXP_REPLACE: Definition
REGEXP_SUBSTR: Definition
REGISTER Procedure: Definition
REGISTERSCHEMA Procedures: Definition
REGISTERURI Procedure: Definition
REGISTERURLHANDLER: Definition
REGISTER_DEPENDENT_OBJECT Procedure: Definition
REGISTER_FOREIGN_QUEUE Procedure: Definition
REGISTER_MVIEW Procedure: Definition
REGR_ (Linear Regression) Functions: Definition
REG_END Procedure: Definition
RELEASE Function: Definition
RELEASE_ALL_SERVICES Procedure: Definition
RELEASE_CALL Procedure: Definition
RELEASE_SERVICE Procedure: Definition
REMAINDER: Definition
REMAP_STGTAB_SQLPROF Procedure: Definition
REMAP_STGTAB_SQLSET Procedure: Definition
REMARK: Definition
REMOVE Procedure: Definition
REMOVEALL Procedure: Definition
REMOVEATTRIBUTE Procedures: Definition
REMOVEATTRIBUTENODE Function: Definition
REMOVECHILD Function: Definition
REMOVENAMEDITEM Function: Definition
REMOVEPARAM Procedure: Definition
REMOVEXSLTPARAM: Definition
REMOVE_EVENT_QUEUE_SUBSCRIBER Procedure: Definition
REMOVE_FILE Procedure: Definition
REMOVE_LOGFILE Procedure: Definition
REMOVE_MSGSYSTEM_LINK Procedure: Definition
REMOVE_PIPE Function: Definition
REMOVE_PROPERTY Procedure: Definition
REMOVE_QUEUE Procedure: Definition
REMOVE_RULE Procedure: Definition
REMOVE_SQLSET_REFERENCE Procedure: Definition
REMOVE_STREAMS_CONFIGURATION Procedure: Definition
REMOVE_SUBSCRIBER Procedure: Definition
REMOVE_WINDOW_GROUP_MEMBER Procedure: Definition
RENAME: Definition
RENAMERESOURCE Procedure: Definition
RENAME_COLUMN Procedure: Definition
RENAME_MODEL Procedure: Definition
RENAME_SCHEMA Procedure: Definition
RENAME_TABLE Procedure: Definition
REPFOOTER: Definition
REPHEADER: Definition
REPLACE: Definition
REPLACECHILD Function: Definition
REPLACEDATA Procedure: Definition
REPLICATION_DEPENDENCY_TRACKING: Definition
REPORT Function: Definition
REPORT_TUNING_TASK Function: Definition
REQ Type: Definition
REQUEST Function: Definition
REQUEST_PIECES Function: Definition
RESETPARAMS Procedure: Definition
RESET_BUFFER Procedure: Definition
RESET_JOB_ARGUMENT_VALUE Procedures: Definition
RESET_PACKAGE Procedure: Definition
RESET_PARAM_DEFAULTS Procedure: Definition
RESET_SESSION Procedure: Definition
RESET_SQLWKLD Procedure: Definition
RESET_SUBSCRIBER Procedure: Definition
RESET_TASK Procedure: Definition
RESET_TUNING_TASK Procedure: Definition
RESOLVENAMESPACEPREFIX Function: Definition
RESP Type: Definition
RESTARTQUERY Procedure: Definition
RESTORE Function: Definition
RESTORE_DATABASE_STATS Procedure: Definition
RESTORE_DICTIONARY_STATS Procedure: Definition
RESTORE_FIXED_OBJECTS_STATS Procedure: Definition
RESTORE_SCHEMA_STATS Procedure: Definition
RESTORE_SYSTEM_STATS Procedure: Definition
RESTORE_TABLE_STATS Procedure: Definition
RESTRICT Option: Definition
RESTRICT_REFERENCES Pragma: Definition
RESUME_TUNING_TASK Procedure: Definition
RETURN Statement: Definition
RETURNING INTO Clause: Definition
REVERSE Function: Definition
REVOKE: Definition
REVOKE_ADMIN_PRIVILEGE Procedure: Definition
REVOKE_OBJECT_PRIVILEGE Procedure: Definition
REVOKE_PRIVILEGE Procedure: Definition
REVOKE_QUEUE_PRIVILEGE Procedure: Definition
REVOKE_REMOTE_ADMIN_ACCESS Procedure: Definition
REVOKE_SWITCH_CONSUMER_GROUP Procedure: Definition
REVOKE_SYSTEM_PRIVILEGE Procedure: Definition
REWRITE Hint: Definition
ROLLBACK: Definition
ROLLBACK Procedure: Definition
ROLLBACK Statement: Definition
ROLLBACK_FORCE Procedure: Definition
ROLLBACK_SAVEPOINT Procedure: Definition
ROUND (date): Definition
ROUND (number): Definition
ROWID Pseudocolumn: Definition
ROWIDTOCHAR: Definition
ROWIDTONCHAR: Definition
ROWID_BLOCK_NUMBER Function: Definition
ROWID_CREATE Function: Definition
ROWID_INFO Procedure: Definition
ROWID_OBJECT Function: Definition
ROWID_RELATIVE_FNO Function: Definition
ROWID_ROW_NUMBER Function: Definition
ROWID_TO_ABSOLUTE_FNO Function: Definition
ROWID_TO_EXTENDED Function: Definition
ROWID_TO_RESTRICTED Function: Definition
ROWID_TYPE Function: Definition
ROWID_VERIFY Function: Definition
ROWNUM Pseudocolumn: Definition
ROW_LIST DATA TYPE: Definition
ROW_NUMBER: Definition
RPAD: Definition
RTRIM: Definition
RULE Hint: Definition
RUN: Definition
RUN Procedure: Definition
RUN_CHAIN Procedures: Definition
RUN_JOB Procedure: Definition
SCHEDULE_PURGE Procedure: Definition
SERVICE_NAMES: Definition
SET_GLOBAL_INSTANTIATION_SCN Procedure: Definition
SET_SCHEMA_INSTANTIATION_SCN Procedure: Definition
SET_TABLE_INSTANTIATION_SCN Procedure: Definition
SET_TAG Procedure: Definition
SET_UPDATE_CONFLICT_HANDLER Procedure: Definition
SET_VALUE_DEPENDENCY Procedure: Definition
STREAMS Replication: Definition
TRUNCATE TABLE, TRUNCATE CLUSTER: Definition
V$REPLPROP: Definition
V$REPLQUEUE: Definition
V$STREAMS_POOL_ADVICE: Definition