Home
Home
Help
Help
Contact us
Contact Us

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

Shortcuts to Items in the List

Statements, Keywords, Packages, and Functions

R: Definition, Search for examples
R_SQ: Definition, Search for examples
RAISE Statement: Definition, Search for examples
RAISE Statement: Definition, Search for examples
RAISE_APPLICATION_ERROR Procedure: Definition, Search for examples
RANDOM Procedure: Definition, Search for examples
RANDOM: Definition, Search for examples
RANDOMBYTES Function: Definition, Search for examples
RANDOMINTEGER Function: Definition, Search for examples
RANDOMNUMBER Function: Definition, Search for examples
RANK: Definition, Search for examples
RANK_APPLY Procedure: Definition, Search for examples
RANKING_MEASURE: Definition, Search for examples
RAW: Definition, Search for examples
RAW: Definition, Search for examples
RAW: Definition, Search for examples
RAW: Definition, Search for examples
RAW: Definition, Search for examples
RAW_TO_CHAR Functions: Definition, Search for examples
RAW_TO_NCHAR Functions: Definition, Search for examples
RAW_VALUE: Definition, Search for examples
RB_RECORDS_APPLIED_SEC: Definition, Search for examples
RB_RECORDS_APPLIED_TXN: Definition, Search for examples
RCPT Function: Definition, Search for examples
RE$ATTRIBUTE_VALUE Type: Definition, Search for examples
RE$ATTRIBUTE_VALUE_LIST Type: Definition, Search for examples
RE$COLUMN_VALUE Type: Definition, Search for examples
RE$COLUMN_VALUE_LIST Type: Definition, Search for examples
RE$NAME_ARRAY Type: Definition, Search for examples
RE$NV_ARRAY Type: Definition, Search for examples
RE$NV_LIST Subprograms: Definition, Search for examples
RE$NV_LIST Type: Definition, Search for examples
RE$NV_NODE Type: Definition, Search for examples
RE$RULE_HIT Type: Definition, Search for examples
RE$RULE_HIT_LIST Type: Definition, Search for examples
RE$TABLE_ALIAS Type: Definition, Search for examples
RE$TABLE_ALIAS_LIST Type: Definition, Search for examples
RE$TABLE_VALUE Type: Definition, Search for examples
RE$TABLE_VALUE_LIST Type: Definition, Search for examples
RE$VARIABLE_TYPE Type: Definition, Search for examples
RE$VARIABLE_TYPE_LIST Type: Definition, Search for examples
RE$VARIABLE_VALUE Type: Definition, Search for examples
RE$VARIABLE_VALUE_LIST Type: Definition, Search for examples
READ Procedures: Definition, Search for examples
READ: Definition, Search for examples
READ2CLOB Function: Definition, Search for examples
READ_CLIENT_INFO Procedure: Definition, Search for examples
READ_ERROR: Definition, Search for examples
READ_LINE Function: Definition, Search for examples
READ_LINE Procedure: Definition, Search for examples
READ_MODULE Procedure: Definition, Search for examples
READ_ONLY Procedure: Definition, Search for examples
READ_RAW Function: Definition, Search for examples
READ_RAW Procedure: Definition, Search for examples
READ_TEXT Function: Definition, Search for examples
READ_TEXT Procedure: Definition, Search for examples
READ_WRITE Procedure: Definition, Search for examples
READONLY_PATH: Definition, Search for examples
REASSOCIATE_FBA Procedure: Definition, Search for examples
REBUILD Procedure: Definition, Search for examples
REBUILD_FREELISTS Procedure: Definition, Search for examples
REBUILDHIERARCHICALINDEX Procedure: Definition, Search for examples
REBUILDHIERARCHICALINDEX Procedure: Definition, Search for examples
RECEIVE_MESSAGE Function: Definition, Search for examples
RECHECK Function: Definition, Search for examples
RECOMMEND_ALL: Definition, Search for examples
RECOMMEND_MV_EXACT_TEXT_MATCH: Definition, Search for examples
RECOMMENDED_TABLESPACES: Definition, Search for examples
RECOMP_PARALLEL Procedure: Definition, Search for examples
RECOMP_SERIAL Procedure: Definition, Search for examples
RECONFIGCACHE Procedure: Definition, Search for examples
RECORD Types: Definition, Search for examples
RECORD Types: Definition, Search for examples
RECORD Types: Definition, Search for examples
RECORD Types: Definition, Search for examples
RECORD Types: Definition, Search for examples
RECORD Types: Definition, Search for examples
RECORD Types: Definition, Search for examples
RECORD#: Definition, Search for examples
RECORD_APPLIED_DDL: Definition, Search for examples
RECORD_COUNT: Definition, Search for examples
RECORD_SKIP_DDL: Definition, Search for examples
RECORD_SKIP_ERRORS: Definition, Search for examples
RECORD_UNSUPPORTED_OPERATIONS: Definition, Search for examples
RECOVER: Definition, Search for examples
RECOVER: Definition, Search for examples
RECOVER_OPERATION Procedure: Definition, Search for examples
RECURSIVE_CALLS_SEC: Definition, Search for examples
RECURSIVE_CALLS_TXN: Definition, Search for examples
REDIRECT_URL Procedure: Definition, Search for examples
REDO_ALLOCATION_HIT: Definition, Search for examples
REDO_GENERATED_SEC: Definition, Search for examples
REDO_GENERATED_TXN: Definition, Search for examples
REDO_WRITES_SEC: Definition, Search for examples
REDO_WRITES_TXN: Definition, Search for examples
REF_CONSTRAINT: Definition, Search for examples
REFRESH Procedures: Definition, Search for examples
REFRESH_ALL_MVIEWS Procedure: Definition, Search for examples
REFRESH_CATEGORY Function: Definition, Search for examples
REFRESH_DEPENDENT Procedures: Definition, Search for examples
REFRESH_GROUP: Definition, Search for examples
REFRESH_GROUPED_POLICY Procedure: Definition, Search for examples
REFRESH_METHOD: Definition, Search for examples
REFRESH_MODE: Definition, Search for examples
REFRESH_MVIEW Procedure: Definition, Search for examples
REFRESH_POLICY Procedure: Definition, Search for examples
REG_END Procedure: Definition, Search for examples
REGEXP: Definition, Search for examples
REGISTER Procedure: Definition, Search for examples
REGISTER Procedure: Definition, Search for examples
REGISTER_CSID_NULL: Definition, Search for examples
REGISTER_DEPENDENT_OBJECT Procedure: Definition, Search for examples
REGISTER_FOREIGN_QUEUE Procedure: Definition, Search for examples
REGISTER_MVIEW Procedure: Definition, Search for examples
REGISTER_NODOCID: Definition, Search for examples
REGISTERSCHEMA Procedures: Definition, Search for examples
REGISTERSTORE Procedure: Definition, Search for examples
REGISTERSTORECOMMAND Procedure: Definition, Search for examples
REGISTERTOKENTABLESET Procedure: Definition, Search for examples
REGISTERURI Procedure: Definition, Search for examples
REGISTERURLHANDLER: Definition, Search for examples
REGRESSION: Definition, Search for examples
REINITIALIZE: Definition, Search for examples
RELEASE Function: Definition, Search for examples
RELEASE: Definition, Search for examples
REMAP_CONNECTION Procedure: Definition, Search for examples
REMAP_DATAFILE: Definition, Search for examples
REMAP_SCHEMA: Definition, Search for examples
REMAP_STGTAB_SQLPROF Procedure: Definition, Search for examples
REMAP_STGTAB_SQLSET Procedure: Definition, Search for examples
REMAP_TABLE: Definition, Search for examples
REMAP_TABLESPACE: Definition, Search for examples
REMAPCOMPOSITEKEYS: Definition, Search for examples
REMARK: Definition, Search for examples
REMARK: Definition, Search for examples
REMOVE Procedure: Definition, Search for examples
REMOVE Procedure: Definition, Search for examples
REMOVE Procedure: Definition, Search for examples
REMOVE Procedure: Definition, Search for examples
REMOVE_AGENT Procedure: Definition, Search for examples
REMOVE_CAPTURE Procedure: Definition, Search for examples
REMOVE_CATEGORY Procedure: Definition, Search for examples
REMOVE_COLORED_SQL Procedure: Definition, Search for examples
REMOVE_COST_MATRIX Procedure: Definition, Search for examples
REMOVE_EVENT_QUEUE_SUBSCRIBER Procedure: Definition, Search for examples
REMOVE_FILE Procedure: Definition, Search for examples
REMOVE_GROUP_MEMBER Procedure: Definition, Search for examples
REMOVE_JOB Procedure: Definition, Search for examples
REMOVE_JOB_EMAIL_NOTIFICATION Procedure: Definition, Search for examples
REMOVE_LOGFILE Procedure: Definition, Search for examples
REMOVE_MSGSYSTEM_LINK Procedure: Definition, Search for examples
REMOVE_OPTION Procedure: Definition, Search for examples
REMOVE_PAIR Member Procedure: Definition, Search for examples
REMOVE_PIPE Function: Definition, Search for examples
REMOVE_PROXY Procedure: Definition, Search for examples
REMOVE_QUEUE Procedure: Definition, Search for examples
REMOVE_RULE Procedure: Definition, Search for examples
REMOVE_RULE Procedure: Definition, Search for examples
REMOVE_SCHEDULE_ORDERING Procedure: Definition, Search for examples
REMOVE_SCHEME Procedure: Definition, Search for examples
REMOVE_SQLSET_REFERENCE Procedure: Definition, Search for examples
REMOVE_STMT_FROM_HANDLER Procedure: Definition, Search for examples
REMOVE_STMT_HANDLER: Definition, Search for examples
REMOVE_STREAMS_CONFIGURATION Procedure: Definition, Search for examples
REMOVE_SUBSCRIBER Procedure: Definition, Search for examples
REMOVE_SUBSCRIBER Procedure: Definition, Search for examples
REMOVE_WINDOW_GROUP_MEMBER Procedure: Definition, Search for examples
REMOVEALL Procedure: Definition, Search for examples
REMOVEATTRIBUTE Procedures: Definition, Search for examples
REMOVEATTRIBUTENODE Function: Definition, Search for examples
REMOVECHILD Function: Definition, Search for examples
REMOVENAMEDITEM Function: Definition, Search for examples
REMOVEPARAM Procedure: Definition, Search for examples
REMOVEXSLTPARAM: Definition, Search for examples
REMOVEXSLTPARAM: Definition, Search for examples
RENAME_BASELINE Procedure: Definition, Search for examples
RENAME_COLUMN Member Procedure: Definition, Search for examples
RENAME_COLUMN Procedure: Definition, Search for examples
RENAME_FAILED: Definition, Search for examples
RENAME_MODEL Procedure: Definition, Search for examples
RENAME_SCHEMA Procedure: Definition, Search for examples
RENAME_TABLE Procedure: Definition, Search for examples
RENAMEPATH Procedure: Definition, Search for examples
RENAMEPATH Procedures: Definition, Search for examples
RENAMERESOURCE Procedure: Definition, Search for examples
RENDER_EVENT: Definition, Search for examples
RENDERINGMODE: Definition, Search for examples
REPFOOTER: Definition, Search for examples
REPFOOTER: Definition, Search for examples
REPHEADER: Definition, Search for examples
REPHEADER: Definition, Search for examples
REPLACECHILD Function: Definition, Search for examples
REPLACEDATA Procedure: Definition, Search for examples
REPORT Function: Definition, Search for examples
REPORT Function: Definition, Search for examples
REPORT_ANALYSIS_TASK Function: Definition, Search for examples
REPORT_AUTO_TUNING_TASK Function: Definition, Search for examples
REPORT_AUTO_TUNING_TASK Function: Definition, Search for examples
REPORT_COL_USAGE Function: Definition, Search for examples
REPORT_DATE_FORMAT: Definition, Search for examples
REPORT_DIAGNOSIS_TASK Function: Definition, Search for examples
REPORT_SQL_DETAIL Function: Definition, Search for examples
REPORT_SQL_MONITOR Function: Definition, Search for examples
REPORT_SQL_MONITOR_LIST Function: Definition, Search for examples
REPORT_TUNING_TASK Function: Definition, Search for examples
REQUEST Function: Definition, Search for examples
REQUEST Function: Definition, Search for examples
REQUEST_FAILED: Definition, Search for examples
REQUEST_PIECES Function: Definition, Search for examples
RESET: Definition, Search for examples
RESET_ANALYSIS_TASK Procedure: Definition, Search for examples
RESET_BUFFER Procedure: Definition, Search for examples
RESET_DIAGNOSIS_TASK Procedure: Definition, Search for examples
RESET_GLOBAL_PREF_DEFAULTS Procedure: Definition, Search for examples
RESET_JOB Procedure: Definition, Search for examples
RESET_JOB_ARGUMENT_VALUE Procedure: Definition, Search for examples
RESET_PACKAGE Procedure: Definition, Search for examples
RESET_PARAM_DEFAULTS Procedure: Definition, Search for examples
RESET_SESSION Procedure: Definition, Search for examples
RESET_SQLWKLD Procedure: Definition, Search for examples
RESET_SUB_MISSING_LOG_REC: Definition, Search for examples
RESET_SUB_MISSING_MESSAGE: Definition, Search for examples
RESET_SUBSCRIBER Procedure: Definition, Search for examples
RESET_TASK Procedure: Definition, Search for examples
RESET_TUNING_TASK Procedure: Definition, Search for examples
RESETPARAMS Procedure: Definition, Search for examples
RESOLVENAMESPACEPREFIX Function: Definition, Search for examples
RESOURCE_COST: Definition, Search for examples
RESPONSE_TXN: Definition, Search for examples
RESTARTQUERY Procedure: Definition, Search for examples
RESTORE Function: Definition, Search for examples
RESTORE_DATABASE_STATS Procedure: Definition, Search for examples
RESTORE_DEFAULTS Procedure: Definition, Search for examples
RESTORE_DICTIONARY_STATS Procedure: Definition, Search for examples
RESTORE_FIXED_OBJECTS_STATS Procedure: Definition, Search for examples
RESTORE_SCHEMA_STATS Procedure: Definition, Search for examples
RESTORE_SYSTEM_STATS Procedure: Definition, Search for examples
RESTORE_TABLE_STATS Procedure: Definition, Search for examples
RESTOREALL Procedure: Definition, Search for examples
RESTOREALL Procedure: Definition, Search for examples
RESTOREPATH Procedure: Definition, Search for examples
RESTOREPATH Procedure: Definition, Search for examples
RESTRICT_REFERENCES Pragma: Definition, Search for examples
RESULT_CACHE: Definition, Search for examples
RESUME_ANALYSIS_TASK Procedure: Definition, Search for examples
RESUME_DIAGNOSIS_TASK Procedure: Definition, Search for examples
RESUME_REPLAY Procedure: Definition, Search for examples
RESUME_TASK Procedures: Definition, Search for examples
RESUME_TUNING_TASK Procedure: Definition, Search for examples
RETURN Data Type: Definition, Search for examples
RETURN Statement: Definition, Search for examples
RETURN Statement: Definition, Search for examples
RETURN Statement: Definition, Search for examples
RETURN: Definition, Search for examples
REUSE_REPLAY_FILTER_SET Procedure: Definition, Search for examples
REVERSE Function: Definition, Search for examples
REVERSE: Definition, Search for examples
REVOKE_ADMIN_PRIVILEGE Procedure: Definition, Search for examples
REVOKE_OBJECT_PRIVILEGE Procedure: Definition, Search for examples
REVOKE_OBJECT_PRIVILEGE Procedure: Definition, Search for examples
REVOKE_PRIVILEGE Procedure: Definition, Search for examples
REVOKE_PRIVILEGE Procedure: Definition, Search for examples
REVOKE_QUEUE_PRIVILEGE Procedure: Definition, Search for examples
REVOKE_REMOTE_ADMIN_ACCESS Procedure: Definition, Search for examples
REVOKE_SWITCH_CONSUMER_GROUP Procedure: Definition, Search for examples
REVOKE_SYSTEM_PRIVILEGE Procedure: Definition, Search for examples
REVOKE_SYSTEM_PRIVILEGE Procedure: Definition, Search for examples
REVOKE_SYSTEM_PRIVILEGE Procedure: Definition, Search for examples
REVOKE_SYSTEM_PRIVILEGE Procedure: Definition, Search for examples
RLM$EVENTIDS Object Type: Definition, Search for examples
RLS_CONTEXT: Definition, Search for examples
RLS_GROUP: Definition, Search for examples
RLS_POLICY: Definition, Search for examples
RMGR_CONSUMER_GROUP: Definition, Search for examples
RMGR_INTITIAL_CONSUMER_GROUP: Definition, Search for examples
RMGR_PLAN: Definition, Search for examples
RMGR_PLAN_DIRECTIVE: Definition, Search for examples
RNDS: Definition, Search for examples
RNPS: Definition, Search for examples
ROLE: Definition, Search for examples
ROLE: Definition, Search for examples
ROLE_GRANT: Definition, Search for examples
ROLLBACK Procedure: Definition, Search for examples
ROLLBACK Statement: Definition, Search for examples
ROLLBACK_FORCE Procedure: Definition, Search for examples
ROLLBACK_SAVEPOINT Procedure: Definition, Search for examples
ROLLBACK_SEGMENT: Definition, Search for examples
ROOT_MEAN_SQ: Definition, Search for examples
ROWID: Definition, Search for examples
ROWID_BAD_BLOCK: Definition, Search for examples
ROWID_BLOCK_NUMBER Function: Definition, Search for examples
ROWID_CREATE Function: Definition, Search for examples
ROWID_INFO Procedure: Definition, Search for examples
ROWID_INVALID: Definition, Search for examples
ROWID_OBJECT Function: Definition, Search for examples
ROWID_RELATIVE_FNO Function: Definition, Search for examples
ROWID_ROW_NUMBER Function: Definition, Search for examples
ROWID_TO_ABSOLUTE_FNO Function: Definition, Search for examples
ROWID_TO_EXTENDED Function: Definition, Search for examples
ROWID_TO_RESTRICTED Function: Definition, Search for examples
ROWID_TYPE Function: Definition, Search for examples
ROWID_VERIFY Function: Definition, Search for examples
ROWS_PER_SORT: Definition, Search for examples
ROWTYPE_MISMATCH: Definition, Search for examples
ROWTYPE_MISMATCH: Definition, Search for examples
RULE_COUNT: Definition, Search for examples
RULES Manager Types: Definition, Search for examples
RULES TYPEs: Definition, Search for examples
RUN Procedure: Definition, Search for examples
RUN: Definition, Search for examples
RUN: Definition, Search for examples
RUN_CHAIN Procedure: Definition, Search for examples
RUN_CHECK Procedure: Definition, Search for examples
RUN_JOB Procedure: Definition, Search for examples
RUN_TASK Procedure: Definition, Search for examples
RUNTIME_INFO Record Type: Definition, Search for examples