November 2002
-
November 27, 2002
27
Nov'02
Accessing non-Oracle databases using stored procedures and JDBC
This tip demonstrates how to connect to non-Oracle databases from within Oracle stored procedures using JDBC. Continue Reading
-
November 26, 2002
26
Nov'02
Most efficient way to remove duplicate rows
This script uses a hash join, the most performance efficient way of joining huge tables, to find duplicate rows. Continue Reading
-
November 26, 2002
26
Nov'02
Keeping Optimizer statistics up to date
This script can be scheduled to run regularly to monitor table usage and keep statistics on schema objects current. Continue Reading
-
November 25, 2002
25
Nov'02
FIRST N rows, TOP N rows, LAST N rows, BOTTOM N rows...
-
November 25, 2002
25
Nov'02
Conditionally summing fields
-
November 25, 2002
25
Nov'02
Caching and pinning revisited
-
November 25, 2002
25
Nov'02
Grouping schemas functionally
-
November 25, 2002
25
Nov'02
Storing and retrieving video clips
-
November 25, 2002
25
Nov'02
Error inserting from text items to Excel file
-
November 25, 2002
25
Nov'02
Checking from which file instance started without changing file
-
November 25, 2002
25
Nov'02
Implementing a data warehouse: Outsource or in-house with consultants?
-
November 25, 2002
25
Nov'02
Closing ref cursor after it's used in a Java program
-
November 25, 2002
25
Nov'02
Rule of thumb for bitmap indexes
-
November 25, 2002
25
Nov'02
Exporting data using a WHERE clause
-
November 25, 2002
25
Nov'02
Error using LogMiner, Part 2
-
November 25, 2002
25
Nov'02
Using the EXP command while database is running
-
November 25, 2002
25
Nov'02
Creating a database with selected database files
-
November 25, 2002
25
Nov'02
Aggregates by day of week
-
November 25, 2002
25
Nov'02
Universal Installer can't install Windows Oracle 8 ODBC driver
-
November 25, 2002
25
Nov'02
Trying to remove datafiles from tablespace