Oracle PL/SQL Category

Quick Search:

Jump to:

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

PARTITIONS - Oracle allows us to ecompose a table or index into smaller, more manageable...

PERCENTILE_CONT - Inverse distribution function that assumes a continuous distribution m...

PERCENTILE_DISC - An inverse distribution function that assumes a discrete distribution ...

PERCENT_RANK - For a row r, PERCENT_RANK calculates the rank of r minus 1, divided by 1 ...

Periodic COMMIT loop - Updating via simple loop, doing a commit every X number of records.

PHP and Oracle: Connect to database - To connect to Oracle from PHP scripts you'll need ...

PHP to Oracle 8 DB abstraction - A database abstraction layer for the PHP Oracle 8 module.

PHP: connect to an Oracle database - This code connects to an Oracle database defined by...

PL/SQL compiler nesting limits - The PL/SQL compiler imposes limits for block, record, s...

PLSQL Errors - A list of some PL/SQL named exceptions.

Populate table from cursor - How to populate a PL/SQL Table from a cursor.

PREDICTION - PREDICTION returns the best prediction for the model. The datatype returned...

PREDICTION_BOUNDS - PREDICTION_BOUNDS returns an object with two NUMBER fields LOWER and...

PREDICTION_COST - PREDICTION_COST is for use with any classification model created by th...

PREDICTION_DETAILS - PREDICTION_DETAILS is for use with decision tree models and single...

PREDICTION_PROBABILITY - PREDICTION_PROBABILITY is for use with classification models cr...

PREDICTION_SET - PREDICTION_SET is for use with classification models created using the ...

Primary Key Constraint - A primary key is a single field or combination of fields that u...

Prompts - A sample of using prompts.

Protect PL/SQL source code - Oracle provides a utility called 'wrap' that can be used to...

RANK - RANK is an analytic function that returns the rank of a value in a group of value...

RAWTOHEX - RAWTOHEX converts raw to a character value containing its hexadecimal equival...

RAWTONHEX - RAWTONHEX converts raw to an NVARCHAR2 character value containing its hexade...

REFTOHEX - REFTOHEX converts argument expr to a character value containing its hexadecim...

REGR_AVGX - REGR_AVGX evaluates the average of the independent variable (expr2) of the r...

REGR_AVGY - REGR_AVGY evaluates the average of the independent variable (expr1) of the r...

REGR_COUNT - REGR_COUNT Returns the number of non-null numbers used to fit the regressio...

REGR_INTERCEPT - REGR_INTERCEPT returns the y-intercept of the regression line. After th...

REGR_R2 - REGR_R2 returns the coefficient of determination (also called "R-squared" or "...