CoderZone.org

 Category: Oracle PL/SQL

Bookmark and Share

Date: Find first day of the month - Returns the first day of a given month.
Dates: Oddball Stuff - ANSI date-time datatypes and arithmetic can make life difficult and perplexing for the p...
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 languages. They allow you ...
DECOMPOSE - DECOMPOSE is valid only for Unicode characters. DECOMPOSE takes as its argument a string in any dat...
Deferring Constraint Checking - Sometimes it is necessary to defer the checking of certain constraints, most co...
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 DISTINCT clause can onl...
Drop Function - As with many Oracle objects, functions may be dropped with this simple command.
Drop User example - Drop the account that owns the database objects required to run the applications discussed...
Eliminate duplicate records - Simply runs through the table and eliminates duplicate records. Very fast.
Example WITH Clause: Double alias - The WITH query_name clause allows assigning a name to a subquery block. The...
Example WITH Clause: Single alias - The WITH query_name clause provides a way assign a name to a subquery block...
Example WITH using CONNECT BY - The WITH query_name clause provides a way assign a name to a subquery block. Th...
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 the execution plans ch...

© coderzone.org | users online: 10