Oracle PL/SQL Category

Quick Search:

Jump to:

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

Number Functions: CORR - Returns the coefficient of correlation of a set of number pairs.

Number Functions: COUNT - Returns a frequency distribution.

Number Functions: COUNT (running count) - Returns a running count of all records or by p...

Number Functions: Radians - Converts degrees to radians.

Number Functions: Random - Returns a random number between 0.0 and 1.0

Number Functions: RANK - Calculates the rank of a value in a group of values.

Number Functions: RATIO_TO_REPORT - Computes the ratio of a value to the sum of a set of...

Number Functions: Round to integer - Returns nearest integer to argument.

Number Functions: Round to n - Rounds to n decimal places

Number Functions: Truncate to n - truncate to n decimal places

NUMTODSINTERVAL - NUMTODSINTERVAL converts n to an INTERVAL DAY TO SECOND literal. The a...

NUMTOYMINTERVAL - NUMTOYMINTERVAL converts number n to an INTERVAL YEAR TO MONTH literal...

NVL - Returns a Value if the Expression IS NULL

NVL: Replace NULL values - The function NVL replaces null values with a stated value. In...

oci_bind_array_by_name() example - Binds the PHP array var_array to the Oracle placehol...

OR Condition - The OR condition allows you to create an SQL statement where records are ...

Oracle Exception Handling - In PL/SQL, a warning or error condition is called an excepti...

Oracle SQL Hints - All hints except /*+ rule */ cause the CBO to be used. Therefore, it...

Oracle with PHP - The following example demonstrates how data can be SELECTed and manipu...

ORDER BY Clause - The ORDER BY clause is used by, and is the last clause of, a SELECT s...

OVER PARTITION BY - This demo returns employees that are making above average salary in ...

PACKAGES: initialization - Package specifications can be used to initialize variables an...

PACKAGES: one function - Packages can hold functions as well as procedures. Here is a si...

PACKAGES: one procedure - This is a bare-bones package example with both the package spe...

PACKAGES: overloading - Packages can contain multiple iterations of procedures with the ...

PACKAGES: related queries - Queries to retrieve package metadata.