SELECT: Case insensitive search - Prior to Oracle10g release 2, case insensitive queries... SELECT: Get DISTINCT / UNIQUE values - The UNIQUE command retrieves only unique data ent... SELECT: Get UNIQUE / DISTINCT values - The DISTINCT command retrieves only unique data e... 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 PL/SQL - Send e-mail messages and attachments directly ... 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... SEQUENCE: Reset a sequence to a predefined number - A small PL/SQL procedure that resets... 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 Erroor 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...