Oracle PL/SQL Category

Quick Search:

Jump to:

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

SELECT: Case insensitive search - Prior to Oracle10g release 2, case insensitive queries...

SELECT: Get DISTINCT or UNIQUE values - The UNIQUE command retrieves only unique data en...

SELECT: Get UNIQUE and DISTINCT values - The DISTINCT command retrieves only unique data...

SELECT: Partition Select - You can select rows from a single partition of a partitioned ...

SELECT: Scalar Select - The scalar SELECT command retrieves columns and rows from a tabl...

SELECT: Select For Update - The Select For Update statement allows you to lock the recor...

SELECT: Using Functions - SELECT allows the use of functions within its scope, as shown ...

Selecting a Random Row - Sometimes all you need is a random row. This will do it for you.

Self-join example and syntax - A self-join is a way of joining a table to itself. Th...

Send email from Oracle - With Oracle8i, you can send e-mail messages directly from PL/SQ...

Send email with attachments from PLSQL - Send e-mail messages and attachments directly f...

SEQUENCE: Autonumber into two tables - Use a SEQUENCE autonumber and insert into two tables.

SEQUENCE: Create sequence demo - A sequence is an object in Oracle that is used to gener...

SEQUENCE: Demo code and Examples - In Oracle, you can create an autonumber field by usin...

SEQUENCE: Find sequence MAX value - Here's how to find the MAX value in a sequence.

SEQUENCE: get sequence value into variable - Oracle doesn't let you use sequences direct...

Show active transactions - Shows active (in progress) transactions.

Show all links - This code will show all the links for a given database @c:\oracle\s...

Show all User Locks - Does just what it says: shows all user locks on the system.

Show info on current context - Reports information about your current database context (...

Show installed modules - Shows the Oracle Application modules installed and the versions...

Show Nth highest value - Select and display the Nth highest value from a table.

Show rollback segment stats - Display the current rollback segment statistics.

Show Runtime in days and hours - Displays database runtime in days and hours to SYS or S...

Shutdown on call - Shutdown immediate call from service stop.

Simple DUAL examples - DUAL is used for calculations that don't touch tables.

Spell out numbers to words - This handy little script will spell out numbers to words. F...

SQL Code and SQL Error Messages - Captures Oracle error codes and their associated messages.

SQL*Loader - SQL*Loader is a bulk loader utility used for moving data from external file...