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. ...