Development-Tasks

PL/SQL

PL/SQL Send Mail Procedure

Password Change Reminder Procedure

Autonomous Transactions (10g)

Trigger to Create Public Synonyms

SQL *Plus

SQL *Plus Ignore Ampersands

Invoke SQL *Plus through Textpad

UNION (ALL), INTERSECT, MINUS Operators

Append DateTime to Spool File

Handy values for Oracle Date Functions

Create Table As

The glogin.sql File

CHANGE text on the current line

Check last DML time - if available

Application Express (APEX)

Change Apex 4.0 Admin Password

Shell Scripting (ksh)

SQL Across Multiple Servers

SQL Across Multiple Servers with Password Prompts

Linux Filesystem Alerting Script

Oracle SQL Loader (sqlldr)

Load Multiple (over 100,000) Files