Code Tips

Welcome to Code Tips. Read the tips below and contact the authors directly with your questions.

Find answers to your most difficult questions in the full-text searchable Ask Tom forum. And don't forget to join Oracle Technology Network for more code samples, discussion forums, and other Oracle technology information.

11/28/05	Track CPU Usage by Jony Safi
11/14/05	Find the Hard Parse Rate by Vishwamithran S
10/31/05	Check Log Number Status by Ittichai Chammavanijakul
10/17/05	Compile Dependent Objects by Hector Ulloa
10/3/05	View Running SQL by Jignesh Prajapati
9/19/05	Check for Unique Column Values by Sailaja Pasupuleti
9/05/05	Enable/Disable Foreign Key Constraints by Paolo Mariani
8/22/05	Filling in the LAST Leading Value by Robert Ware
8/08/05	Search Stored Objects by Ilya Petrenko
7/25/05	Query to Find Second Saturday by Chacravarthi Ramasami
7/11/05	Datafile Location and Storage Information by Pavel Descoteaux
6/27/05	Daily Count and Size of Redo Log Space (Single Instance) by Ilya Petrenko
6/20/05	Getting Cumulative Sum Using Oracle Analytical Functions by Robert Ware
6/13/05	Swap Words in a String by Chacravarthi Ramasami
6/06/05	Convert Seconds to Hours, Minutes, and Seconds by Pablo Rovedo
5/23/05	Getting Cumulative Sum by Chacravarthi Ramasami
5/16/05	Counting Strings (Alternative) by Ilya Petrenko
5/09/05	Find Unmatched Data (Old School) by Gabriel Wieskamp
5/02/05	Append Commit After Each DML by Xiang Gao
4/25/05	Search Using Dynamic PL/SQL by Bhagwan Singh
4/11/05	Protect Objects from Deletion by Laurent Leturgez
3/28/05	Determine How Deep FK Constraints - Alternate Version by Zlatko Sirotic
3/21/05	Find Full Table Scans by Shyam Prabhudesai
2/28/05	Transaction Tracker by Jony Safi
2/21/05	Counting Strings by Potkin Nemat
2/14/05	Report Materialized View Log Entries by Jay Zhang
1/17/05	Convert Numbers into Words by Murugesan Appukutty
1/10/05	Identify Prime Numbers by Sandesh Mali
1/3/05	Generate Horizontal-to-Vertical by Ilya Petrenko