Oracle PL/SQL Category

Quick Search:

Jump to:

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

Dates: Oddball Stuff - ANSI date-time datatypes and arithmetic can make life difficult a...

DBA triggers - Returns Trigger details.

DBA Extents - Returns details of dba_extents

DBA Free Space - Returns details of available space in particular tablespaces.

DBA Jobs - Returns details of currently running jobs.

DBA Links - Returns a list of database links and their owners.

DBA Objects - Returns a summary of object types by the tablespaces where they reside.

DBA Roles - Returns a list of grantees and granted roles.

DBA Sessions - Returns a list of users and their session details.

DBA Tablespaces - Returns tablespace details.

DBA Users - Returns user details.

Declaring Variables - Variables are very useful in PL/SQL, indeed in all programming lan...

DECOMPOSE - DECOMPOSE is valid only for Unicode characters. DECOMPOSE takes as its argum...

Deferring Constraint Checking - Sometimes it is necessary to defer the checking of certa...

DENSE_RANK - Ranks items in a group leaving no gaps in ranking sequence when there are ties.

Detect Leap Year - Detect leap years (useful for calendar functions, scheduling, etc).

Display and release DBMS_LOCK locks - Release DBMS_LOCK locks on database.

Display database SGA statistics - Handy routine to display the database's SGA statistics.

Display locks and latches - Display database locks and latches (with tables names, etc).

Distinct - The DISTINCT clause allows you to remove duplicates from the result set. The ...

Drop Function - As with many Oracle objects, functions may be dropped with this simple c...

Drop User example - Drop the account that owns the database objects required to run the...

Eliminate duplicate records - Simply runs through the table and eliminates duplicate rec...

EXISTS - Sample of the use of 'EXISTS' clause in SQL

EXISTS 2 - Another example of the use of the 'EXISTS' clause.

Explain Plan - EXPLAIN PLAN output shows how Oracle executes SQL statements and displays...

EXPORT - An example of using Oracle's EXPORT functionality.

Extents - Creates a view with details about clusters and extents.

FEATURE_ID - FEATURE_ID returns an Oracle NUMBER that is the identifier of the feature w...

FEATURE_SET - FEATURE_SET returns a varray of objects containing all possible features. ...