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
Conditionally summing fields
-
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
Rule of thumb for bitmap indexes
-
November 25, 2002
25
Nov'02
Database installation for beginners
-
November 25, 2002
25
Nov'02
Aggregates by day of week
-
November 25, 2002
25
Nov'02
Caching and pinning revisited
-
November 25, 2002
25
Nov'02
Latest contract period for each employee
-
November 25, 2002
25
Nov'02
Testing if a string is a number
-
November 25, 2002
25
Nov'02
FIRST N rows, TOP N rows, LAST N rows, BOTTOM N rows...
-
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
-
November 25, 2002
25
Nov'02
Reorganizing a fragmented tablespace
-
November 25, 2002
25
Nov'02
Creating an AFTER LOGON trigger
-
November 25, 2002
25
Nov'02
Grouping schemas functionally