Free Newsletters:
DatabaseJournal  
DBANews
Database Journal
Search Database Journal:
 
MS SQL Oracle DB2 Access MySQL PostgreSQL Sybase PHP SQL Etc SQL Scripts & Samples Links Database Forum DBA Videos
internet.com

» Database Journal Home
» Database News
» DBA Videos
» Database Articles
» Database Tutorials
MS SQL
Oracle
MS Access
MySQL
DB2
» RESOURCES
Database Tools
SQL Scripts & Samples
Links
» Database Forum
» DBA Jobs
» Sitemap

News Via RSS Feed



follow us on Twitter

Marketplace Partners
Be a Marketplace Partner

internet.commerce
Be a Commerce Partner


















Apple: 1M New iPhones Sold, Apologies for Snafus

T-Mobile's Next Android Phone: myTouch 3G

Firms Push Cloud, Virtualization for IT Niches

internet.com
IT
Developer
Internet News
Small Business
Personal Technology

Search internet.com
Advertise
Corporate Info
Newsletters
Tech Jobs
E-mail Offers


Database Journal | DBA Support | SQLCourse | SQLCourse2








Featured Database Articles

SQL Scripts & Samples

Session Information 6/29
Use this script to find the session information.

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.

Add Your Script

SQL Scripts & Samples Archives







Latest Forum Threads
SQL Scripts & Samples Forum
Topic By Replies Updated
What program was used to create a script? joelw 1 June 27th, 11:04 AM
Query to search text in string mac300 7 July 31st, 08:13 AM
how to access vb6 forms from sql Bazar 0 June 28th, 01:08 PM
Joining 3 tables nijojo 0 June 4th, 08:43 AM