Home

Help

SQL and PL/SQL Syntax and Examples: R

Shortcuts to Items in the List

Statements, Keywords, Packages, and Functions

RAISE Statement: Definition , Search for examples

RANDOM Function: Definition , Search for examples

RANK: Definition , Search for examples

RATIO_TO_REPORT: Definition , Search for examples

RAW: Definition , Search for examples

RAWTOHEX: Definition , Search for examples

READ ONLY: Definition , Search for examples

READ ONLY / READ WRITE Example: Definition , Search for examples

READ ONLY | READ WRITE: Definition , Search for examples

READ Procedure: Definition , Search for examples

READ WRITE: Definition , Search for examples

READ_CLIENT_INFO Procedure: Definition , Search for examples

READ_MODULE Procedure: Definition , Search for examples

READ_ONLY Procedure: Definition , Search for examples

READ_WRITE Procedure: Definition , Search for examples

REASONS: Definition , Search for examples

REBUILD: Definition , Search for examples

REBUILD_FREELISTS Procedure: Definition , Search for examples

RECEIVE_MESSAGE Function: Definition , Search for examples

RECOMMEND_MV Procedure: Definition , Search for examples

RECOMMEND_MV_W Procedure: Definition , Search for examples

RECOVER: Definition , Search for examples

RECTIFY Procedure: Definition , Search for examples

REF: Definition , Search for examples

REF CURSOR: Definition , Search for examples

REF Example: Definition , Search for examples

REF Examples: Definition , Search for examples

REFRESH Procedure: Definition , Search for examples

REFRESH_ALL_MVIEWS Procedure: Definition , Search for examples

REFRESH_DEPENDENT Procedure: Definition , Search for examples

REFRESH_POLICY Procedure: Definition , Search for examples

REFRESH_SNAPSHOT_REPGROUP Procedure: Definition , Search for examples

REFTOHEX: Definition , Search for examples

REGISTER Procedure: Definition , Search for examples

REGISTER_PROPAGATOR Procedure: Definition , Search for examples

REGISTER_SNAPSHOT Procedure: Definition , Search for examples

REGISTER_SNAPSHOT_REPGROUP Procedure: Definition , Search for examples

REGISTER_STATISTICS Procedure: Definition , Search for examples

REGISTER_USER_REPGROUP Procedure: Definition , Search for examples

REGR_ (linear regression) functions: Definition , Search for examples

REGR_COUNT Examples: Definition , Search for examples

REGR_R2 Examples: Definition , Search for examples

RELEASE Function: Definition , Search for examples

RELOCATE_MASTERDEF Procedure: Definition , Search for examples

RELY | NORELY: Definition , Search for examples

REMARK: Definition , Search for examples

REMOVE Procedure: Definition , Search for examples

REMOVEALL Procedure: Definition , Search for examples

REMOVE_MASTER_DATABASES Procedure: Definition , Search for examples

REMOVE_PIPE Function: Definition , Search for examples

REMOVE_SUBSCRIBER Procedure: Definition , Search for examples

RENAME: Definition , Search for examples

RENAME FILE: Definition , Search for examples

RENAME GLOBAL_NAME: Definition , Search for examples

RENAME TO: Definition , Search for examples

RENAME TO new_outline_name: Definition , Search for examples

REPCAT_IMPORT_CHECK Procedure: Definition , Search for examples

REPFOOTER: Definition , Search for examples

REPHEADER: Definition , Search for examples

REPLACE: Definition , Search for examples

REPLACE AS OBJECT: Definition , Search for examples

REPLACE_BASE_CAPS Procedure: Definition , Search for examples

REPLACE_BASE_DD Procedure: Definition , Search for examples

REPLACE_CLASS_CAPS Procedure: Definition , Search for examples

REPLACE_CLASS_DD Procedure: Definition , Search for examples

REPLACE_CLASS_INIT Procedure: Definition , Search for examples

REPLACE_FDS_CLASS Procedure: Definition , Search for examples

REPLACE_FDS_INST Procedure: Definition , Search for examples

REPLACE_INST_CAPS Procedure: Definition , Search for examples

REPLACE_INST_DD Procedure: Definition , Search for examples

REPLACE_INST_INIT Procedure: Definition , Search for examples

REPLICATION_IS_ON Function: Definition , Search for examples

REPLICATION_OFF Procedure: Definition , Search for examples

REPLICATION_ON Procedure: Definition , Search for examples

REQUEST Function: Definition , Search for examples

REQUEST_PIECES Function: Definition , Search for examples

RESET COMPATIBILITY: Definition , Search for examples

RESET_BUFFER Procedure: Definition , Search for examples

RESET_PACKAGE Procedure: Definition , Search for examples

RESOLVE | COMPILE: Definition , Search for examples

RESOLVER: Definition , Search for examples

RESOURCE_MANAGER_PLAN = plan_name: Definition , Search for examples

RESTRICT Option: Definition , Search for examples

RESTRICTED SESSION: Definition , Search for examples

RESTRICT_REFERENCES Pragma: Definition , Search for examples

RESUME_MASTER_ACTIVITY Procedure: Definition , Search for examples

RESUME_PROFILER Function: Definition , Search for examples

RESUME_SUBSET_OF_MASTERS Procedure: Definition , Search for examples

RETURN: Definition , Search for examples

RETURN Statement: Definition , Search for examples

RETURNING INTO ...: Definition , Search for examples

RETURNS: Definition , Search for examples

REUSE: Definition , Search for examples

REVERSE: Definition , Search for examples

REVERSE Function: Definition , Search for examples

REVOKE: Definition , Search for examples

REVOKE_ADMIN_ANY_SCHEMA Procedure: Definition , Search for examples

REVOKE_ADMIN_SCHEMA Procedure: Definition , Search for examples

REVOKE_QUEUE_PRIVILEGE Procedure: Definition , Search for examples

REVOKE_SWITCH_CONSUMER_GROUP Procedure: Definition , Search for examples

REVOKE_SYSTEM_PRIVILEGE Procedure: Definition , Search for examples

RNDS: Definition , Search for examples

RNPS: Definition , Search for examples

ROLLBACK: Definition , Search for examples

ROLLBACK Procedure: Definition , Search for examples

ROLLBACK Statement: Definition , Search for examples

ROLLBACK TO: Definition , Search for examples

ROLLBACK_FORCE Procedure: Definition , Search for examples

ROLLBACK_SAVEPOINT Procedure: Definition , Search for examples

ROUND (date function): Definition , Search for examples

ROUND (number function): Definition , Search for examples

ROWID: Definition , Search for examples

ROWID Datatype: Definition , Search for examples

ROWID Example: Definition , Search for examples

ROWID Types: Definition , Search for examples

ROWIDTOCHAR: 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_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

ROWNUM: Definition , Search for examples

ROW_NUMBER: Definition , Search for examples

RPAD: Definition , Search for examples

RTRIM: Definition , Search for examples

RUN: Definition , Search for examples

RUN Procedure: Definition , Search for examples

RUNTIME_INFO: Definition , Search for examples