Code Tips

Welcome to Code Tips. Here you can share your knowledge with other Oracle users by submitting tips and techniques. 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.

12/25/06	Collecting Percentage of CPU Used by Consumer Group by Marco Gilbert
12/11/06	User Logon Validation Trigger by Babu Rangasamy
11/27/06	Count Repeated Strings by Jose Luis Messina
11/13/06	Generate Permutations for Characters or Numbers by Frank Zhou
10/30/06	Revalidating Invalidated Views by Bruno Vroman
10/16/06	Concatenate Multiple Column Records by Galina Petrenko
10/02/06	Inserting Spaces by Frank Zhou
9/18/06	Multibyte Debug Script by Michael Kleiser
9/4/06	Get Information on Current Queries by Laurent Leturgez
8/21/06	Identify Tables That Need Space by Diwaker Johar
8/7/06	Read the Alert.log File by Seetaram Mehra
7/24/06	Identify Large Indexes by Vishwamithran S.
7/10/06	Date Ranges by Galina Petrenko
6/26/06	Tracing the Sessions(s) of a Given User by Bruno Vroman
6/12/06	Re-Order Characters in a Column by Frank Zhou
5/29/06	Oracle 10g Fibonacci Sequence (SQL Model) by Marcio Portes
5/15/06	Compile All Dependent Objects by Hector Gabriel Ulloa Ligarius
5/1/06	Temporary Tablespace Usage by Aron Tunzi
4/17/06	Multiple Partitioning by Diwaker Johar
4/03/06	Compute Totals and Percentages by Keshav Chennakeshav
3/20/06	Log Switch Activity by Warren Nash
3/06/06	Open Cursor Count by Vishwamithran S.
2/20/06	Tablespace Free (and more) Report by Jayant Kulkarni
2/06/06	Track and Monitor Resources by Luis Adalberto
1/23/06	Grouping Function Plus Analysis by Diwaker Johar
1/09/06	Script to Find User information and More by Pankaj Borole