Oracle PL/SQL Category

Quick Search:

Jump to:

To view the original pages (which were formerly called "Morgan's Library"), you can click here.

REGR_SLOPE - REGR_SLOPE returns the slope of the line. After the elimination of null (ex...

REGR_SXX - REGR_SXX makes the following computation after eliminating NULL (expr1, expr2...

REGR_SXY - REGR_SXY makes the following computation after eliminating NULL (expr1, expr2...

REGR_SYY - REGR_SYY makes the following computation after eliminating NULL (expr1, expr2...

Regular Expressions: Regexp Cheat Sheet - With version 10g, Oracle Database offers 4 reg...

Regular Expressions: RegExp examples one - Examples of the various Oracle-supported regu...

Regular Expressions: RegExp examples three - Patterns for matching Social Security Numbe...

Regular Expressions: RegExp examples two - Search for control (non-printing) characters ...

Regular Expressions: REGEXP_LIKE - REGEXP_LIKE is similar to the LIKE condition, except ...

Regular Expressions: REGEXP_REPLACE - The REGEXP_REPLACE function works by looking for ...

Regular Expressions: REGEXP_SUBSTR - REGEXP_SUBSTR extends the functionality of the SUBS...

RIGHT JOIN example and syntax - The RIGHT JOIN (or RIGHT OUTER JOIN) keyword Return all ...

RMAN (Oracle Recovery Manager) - Recovery Manager (or RMAN) is an Oracle provided utilit...

RMAN: Command Summary - Summary of RMAN commands that you can execute at the RMAN prompt...

RMAN: Data Dictionary Objects - A listing of the RMAN Data Dictionary objects. Also ...

RMAN: Format Directives - A list of the available RMAN format directives.

RMAN: List the most recent Level 0 backups - The RMAN report and list commands aren'...

ROWIDTOCHAR - ROWIDTOCHAR converts a rowid value to VARCHAR2 datatype. The result of thi...

ROWIDTONCHAR - ROWIDTONCHAR converts a rowid value to NVARCHAR2 datatype. The result of...

ROW_NUMBER - Assigns a unique number to each row to which it is applied (either each row...

SCN_TO_TIMESTAMP - This conversion function takes as an argument a number that evaluates...

Search PL/SQL for a string/ key value - This query is a useful way to find out where cer...

SELECT - Use a SELECT statement or subquery to retrieve data from one or more tables, ob...

SELECT into a table - Create a table by SELECTing rows into it from another table or tables.

SELECT name columns - Select specific columns by naming the columns to be used.

SELECT placement - SELECT statements can be placed almost anywhere within a valid SQL co...

SELECT with GROUP BY Clause - The GROUP BY clause is used in conjunction with the aggreg...

SELECT with HAVING Clause - The HAVING clause was added to SQL because the WHERE keyword...

SELECT with SAMPLE clause - The sample clause can be used to return only a percentage of...

SELECT with WHERE Clause - The WHERE clause is used to screen or filter records for spec...