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.

12/13/04	Identify and Count Characters by Aui de la Vega
12/06/04	Find Numeric and Non-Numeric Records by Ilya Petrenko
11/29/04	Suppress Repeating Groups Using RANK (not ROWNUM) by Mohammad Anwar
11/22/04	Tablespace Owner and Usage by Nikhil Dave
11/08/04	Generate Factorials by Kailasanathan Subbaraman
11/01/04	Check TEMP Usage by Jony Safi
10/25/04	Weed Out the Numeric by Amit Zhankar
9/20/04	Find Last Entry from History by Galina Petrenko
9/13/04	Display the PL/SQL Dependency Tree by Casimir Saternos
9/06/04	Another Way to Find the Wait by Wolfgang Genser
8/30/04	EXPLAIN Plan Workaround by Jaromir Nemec
8/23/04	Reset ROWNUM and Suppress Repeating Groups by Satyanarayana Josyula
8/16/04	Get Table Details with SQL*Plus by Ajay Garg
8/09/04	PL/SQL String Tokenizer by Eli Leiba
7/26/04	Track Updates, Changes, and Deletions by Sanjay Ray
7/19/04	Analyze the Analyzed by Jayant Kulkarni
7/12/04	Convert Alphabetical Phone Numbers to Numeric Phone Numbers by Galina Petrenko
6/21/04	Find Active SQL Statements by Sudhindra Chillarige
6/14/04	Auditing and Restricting User Connections by Ajwat Ul-Hasan
6/07/04	Tablespace Growth Report by Vishnu Bhavaraju
5/31/04	Get Unique from Duplicates by Yakov Shlafman
5/24/04	How Many Seconds by Mir Mirhashimaali
5/17/04	Comma, Pipe, or Tab Delimited Output by Galina Petrenko
5/03/04	Row to Column Function by Krishna Kondavadi
4/26/04	Top 10 Segments by V$SEGSTAT Statistic Name by Robert Ware
4/12/04	Generate SQL*Loader Control File for Any Table by Navroz Kapadia
4/05/04	Find Out Where Your PL/SQL Session Is by Sudhindra Chillarige
3/29/04	Optimize Your UNDO Parameters by Marco Gilbert
3/22/04	Deleting Duplicate SYS Constraints by Devanshi Parikh
3/15/04	Simple JDBC Operations from an Applet by Umesh Kulkarni
3/08/04	Blank Lines and Beginning Spaces with DBMS_OUTPUT.PUT_LINE by Pasupuleti Sailaja
3/01/04	Separating Comma Separated Strings by Ramesh Periyasamy
2/23/04	Date/Time Tips, Part 2
2/16/04	Date/Time Tips, Part 1
2/09/04	Generate Spool File Layout by Gautam Arora
2/02/04	Using LogMiner by Frank Pantaleo
1/25/04	Comparing Two Tables: Highlighting the Differences by Sanjay Ray
1/18/04	Fast Reporting from LogMiner by Jutay Medeiros
1/11/04	List Table Names, Rows, and Created Date by Pasupuleti Sailaja
1/04/03	Fast Reset Sequences (Alternative) by Ilya Petrenko
	Code Tips 2003 Index