Data Management: Page

Purpose of roll forward and roll backward

What are rolling forward and rolling backward in backup and recovery?

By Brian Peasland • Sept. 28, 2004

ORA-12801 and ORA-01652 errors on running query

Sept. 23, 2004

PL/SQL to display all tables

By Azim Fahmi • June 7, 2004

Merging datasets with NULL values

A MERGE may appear to work properly, but it's important you check your target dataset to make sure it does. This tip explains why and how.

By Carmen Beitzer • March 15, 2004

Telling EXECUTE IMMEDIATE to commit

June 25, 2003

How to validate zip code, city, and state code

Feb. 18, 2003

FIRST N rows, TOP N rows, LAST N rows, BOTTOM N rows...

Nov. 25, 2002

COALESCE on three columns

Nov. 11, 2002

Age constraint on a date column

Nov. 11, 2002

Getting a row number in a group

Nov. 5, 2002

Checking if row is locked before using it in a procedure

Aug. 13, 2002

Assignment operators explained

June 18, 2002