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 - connect to an Oracle database - This code connects to an Oracle database defined b... PHP and Oracle: Connect to database - To connect to Oracle from PHP scripts you'll need ... PHP/Oracle 8 DB abstraction - A database abstraction layer for the PHP Oracle 8 module. PL/SQL compiler nesting limits - The PL/SQL compiler imposes limits for block, record, s... PL/SQL 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... RegExp - Append first name first letter to last name - Example of using a regular expres... 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 "...