Connecting third-party applications remotely to the database
Parsing a delimited string
Getting counts, displaying distinct columns from a million rows
Mixing ANDs and ORs
Multiple unique NULLs, revisited
Learning Oracle: 8i or 9i on Windows XP Pro?
A one-to-many relationship as a comma-delimited list
Writing an ON INSERT trigger without encountering mutating table error
Workaround for ORA-04043: Can't describe object using db_link
Building a solid foundation for a DBA career
How can I get my data from the .dmp files?
How do we get our servers to share memory?
How often should I be switching log files?
Oracle performance recommendations
Getting information about execution times
What privileges are granted by a role?
Finding users who are not in the BOAT table
Determining how much memory the database uses
Handling time data formats in conversion from DB2
Creating a trigger that is executed only after table insert has been committed
"Roll" memory and "page" memory explained
Problems trying to connect Sybase and Oracle
Problem connecting to database in Developer
Doing a keyword search within contents of memo field
Foreign keys across database instances
Indexing a portion of a column in Oracle
Outer join with three or more tables
Book recommendations for Oracle 8i Enterprise Edition
Resources for OCP exams
Resolving the PDE-POCO11 ORA-12203 error
Where is autotrace getting stats?
The best RAID configuration for Oracle 9i
Server requirements for 100 users on 8i
Is deleted, but not committed, data still in the buffer?
Database server versus application server
Resolving the PLSQL-00453 error
Finding the tables associated with a view
Build Forms 1 vs. Build Internet Applications 1
Error trying to connect internal via SQL*Plus
When will the Oracle8i track (OCP DBA) be retired?
Finding SQL queries used in JSP and EJB
No SQL*Plus help available
Moving redo files from one partition to another
Managed standby error in ARCHIVE MODE
Calling a Java method from a trigger
Checking if row is locked before using it in a procedure
Unique indexes and NULLs
Querying from two different instances
Password protecting INTERNAL
Getting end of communication error when submitting a query
Using SEQUENCE in a Java servlet
Can't create database logged on as sysdba
Selecting all rows of all the tables of a particular user
Making sure records inserted at the same time are pulled out in the correct order
Menu/toolkit error in Server Manager
Corrupted rollback segment
Problem with Oracle Repository Administration Utility
Can I write a trigger that fires at a particular time every day?
Error trying to insert record through database link
Getting the table name within a trigger
Improving performance of uploading a huge data file
Getting the length of a LONG data type and concatenating LONG with VARCHAR2
Connecting Oracle and DB2
Creating record set of time intervals by subtracting timestamp from the previous one
Displaying results horizontally
Inserting LONG RAW data
Java in Oracle
UTLBSTAT at startup, UTLESTAT at shutdown
A beginner's guide to Oracle, particularly SAN setup
Problems uninstalling services
Why is dblink between two instances on same platform slow?
Oracle SQL functions, not PL/SQL
A "simple" crosstab problem
Columns for every day of the month
Selecting specific DATETIME values
Date last updated on a database-driven Web page
Insert in a cursor takes hours to complete
Granting a user privilges only to tables he owns
Finding usage information of a table
Can't install Oracle 8i on Windows ME
Changing the actual SQL of the predicate in the middle of a form
Books and authors, many-to-many
How can I do a full outer join?
Getting a full history of all SQL queries run on the database
Generating a list of unique objects in Oracle versus in MS Access
Inserting an Excel file into a BLOB field
Using 6i on Windows XP
Row-level information from Audit Trail?
On what Windows platforms will 9i run?
Changing the size of the SDU and TDU Net8 parameters
Connecting V$SESSION and V$SQL
Problem installing 8i on Windows 2000
Determining the "SYS" password
Updating a BLOB column without BFILE/create directory options
When can I delete previously backed-up archive files?
Converting FoxPro data to Oracle
Using PRODUCT_USER_PROFILE to disable commands for some roles