Oracle PL/SQL Category

Quick Search:

Jump to:

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

Find Dangerous Users - Finds users with dangerous assigned roles/grants

Find most active SQL in the last hour - Finds the most active SQL code run in the last hour.

Find users with deadly privileges - Finds database users with deadly system privileges a...

FIRST - Returns the row ranked first using DENSE_RANK.

FIRST_VALUE - Returns the first value in an ordered set of values. If the first value in...

FLASHBACK: AS OF clause - When data is accidentally deleted, Flashback can allow the dat...

FLASHBACK: Initialization Parameters - Setting the location and size of flashback recove...

FLASHBACK: Oracle 10G enhancements - Oracle 10G has enhanced the flashback feature furth...

FLASHBACK: Syntax Elements - In Oracle databases, Flashback tools allow administrators a...

FLASHBACK: SYS commands and queries - A set of commands and queries related to flashback...

Floor - Returns the largest integer not greater than argument.

FORALL - FORALL transfers data from a PL/SQL collection to the specified table using col...

FORALL Insert - FORALL transfers data from a PL/SQL collection to the specified table us...

Foreign Key Constraints - The sole purpose of a foreign key constraint is to define a re...

Frequency Distribution - Returns the frequency of a a given value in a set of values.

FULL JOIN example and syntax - The FULL JOIN keyword return rows when there is a match i...

Function For Number Handling - This 'AndNotNum' Function is intended to check a string o...

Function For String Handling - This 'AndNotStr' Function is intended to check a string t...

FUNCTIONS: Create function - Example of how to create a simple function.

FUNCTIONS: date/time - Function to determine the difference between times

FUNCTIONS: DEBUG mode - To examine a function in debug mode.

FUNCTIONS: Deterministic - Deterministic functions do not reference tables and always re...

FUNCTIONS: drop - To drop a function, the function must be in your own schema or you mus...

FUNCTIONS: IF statement - A sample 'IF Statement' Function in PL/SQL.

FUNCTIONS: IN OUT parameter - When you create a procedure or function, you may define pa...

FUNCTIONS: Nested Functions - Oracle functions can be placed within other Oracle functio...

FUNCTIONS: Recompile - Recompile a function without recreating it.

FUNCTIONS: Sample functions - Functions to determine if a number is odd or even.

FUNCTIONS: special restrictions - Restrictions on User-Defined Functions User-defined fu...

FUNCTIONS: System Privileges - These are the system privileges that are related to functions.