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/28/03	Back Up the Control File Image by Faina Goldenberg
12/21/03	Comparing Contents of Two Tables with Identical Structure by Sanjay Ray
12/14/03	Analyze a Table and All Underlying Indexes by Bobby Akbari
12/07/03	Instance Background Processes Information by Galina Petrenko
11/30/03	Find Invalid Synonyms by Vikash Varma
11/23/03	Report Oracle Text Index Sizes by X. Jay Zhang
11/16/03	Getting Database Sessions Information by Govindan K
11/09/03	Fast Reset Sequences by Ilya Petrenko
11/02/03	Report Locking Activity by Puneet Bhandari
10/26/03	Generating Code for Fast Copying by Norman Spector
10/19/03	Check Locking Activity by Puneet Bhandari
10/12/03	Index Rebuild with Cumulative Size Limit by Eugenio Spadafora
10/05/03	See Trends of Fetches of Continued Rows by Robert Ware
9/28/03	Procedure to Reverse a String by Chacravarthi Ramasami
9/21/03	JDBC Connection Caching using OC4J by Jason Bennett
9/14/03	Identify Missing Sequence Numbers with LEAD by Murthy Mamidanna
9/07/03	Identify Missing Sequence Numbers by Murthy Mamidanna
8/31/03	Free Tablespace Report (including Autoextend) by Michael Dinh
8/24/03	Querying When Table and Column Names are Unknown by N. Venkatagiri
8/17/03	Selecting Nth MAX or MIN by Ramcharan Karthic
8/10/03	Avoid a Vicious Cycle by Zlatko Sirotic
8/03/03	Flashback Query in Oracle9i by Jayeshkumar Patel
7/27/03	Displaying Query Output in Long Row Format by Krishna Sarabu
7/20/03	Find Exact Missing Privelege by Jasmin Mehta
7/13/03	Trigger to Prevent Dropping Objects by Rajasekhar Aluru
7/06/03	Working with Microsoft .NET by Danny Chan
6/29/03	Generating ALPHANUMERIC Sequence Using Decode by Biswabijay Bhattacharya
6/22/03	Extracting Table Data Using SELECT Statement into an XML File by Nikhil Goyal
6/15/03	Recreate/Move a (or all) Tablespace(s) from a Database to ... by Rajesh Puneyani
6/08/03	Find Transitive Closure of Parent-Child Relationship in Oracle9i by Marina Gurskaya
6/01/03	Shrink Database Size by Naresh Awasthi
5/25/03	LONG to VARCHAR2 Function by David Jenkins
5/18/03	Mapping Parallel Coordidate Query to Its Slave Queries by Wayne Zhu
5/11/03	Creating Alphanumeric Sequence Using Decode< by Romer L. Vinuya
5/04/03	Finding the Maximum Increment Allowed by Marco Gilbert
4/27/03	Logoff Trigger to Close Session by Kirill Richine
4/20/03	Dynamic Ref Cursor with Dynamic Fetch by Zlatko Sirotic
4/13/03	Exhausted Tablespace Alert by Jayant Kulkarni
4/06/03	Depth-first Grant Tree Traversal by Kirill Richine
3/30/03	Data Block Corruption Alert by Krishna Kakatur
3/16/03	Export TABLE Records into Flat File with INSERTs by Dave Nikhil
3/09/03	Killing Sessions on NT Using Thread Number by Loay AbuZaineh
3/02/03	Pipelined Table Function by Claudiu Ariton
2/23/03	Monitor SYS and SYSTEM Accounts by Daniel Stanley
2/16/03	Determine How Deep FK Constraints by Zlatko Sirotic
2/09/03	Searching for Text within the Trigger Body by Dejan Jovanovic
2/02/03	Definitive Datafile Data Report by Jonathan Reinharz
1/26/03	Calculating Working Days Without Using a Function by Mike Selvaggio
1/19/03	Use SYS_CONTEXT to Obtain Session Information by Ahbaid Gaffoor
1/12/03	Write a Message to the Alert Log by Marco Gilbert