Featured Database Articles

Check if column is NULL or empty 6/22
This script checks to see if a column is NULL or empty.

Database Lock Information 6/15
Look for Object Name and for how long the Lock has been there (Locked Time in Sec).

Find all numbers in a string 6/08
This function finds all the numbers in a string.

IF EXISTS/IF NOT EXISTS 6/01
This script creates a user, if the user does not exist in the db and drops the user, if the user exists in the db.

Drop all user schema tables 5/26
Using cascade constraints you can drop all tables from user schema.

Test SQL Connectivity 5/18
This script tests connectivity to SQL Server box from a client machine when there is no SQL Client.

FULL OUTER JOIN LOOP 5/11
This script displays matched records from two tables when constraints prevent a full outer join.

Database Physical & Actual Size 5/04
Useful on Oracle 8.1.7 onwards or remove the dba_temp_files line & run for earlier versions.

How to compare NULL with NULL 4/25
This script will compare NULL with NULL, because NULL is not equal to NULL.

Delete Older Files 4/20
This script will delete old files from a given folder and all subfolders.

Email Validation 4/13
This procedure returns 0 if invalid mail ID else 1.

Killing Sessions 3/31
Use this script to kill a job and re-run it fter incorporating HINTS.

Hierarchial Loop II 3/30
This script displays all of the employees in SCOTT.EMP table, with all of the bosses they report to, in a hierarchial loop, along with their level in the hierarchy.

Panic SEQuences 3/23
This script will generate all sequences in the database.