Trigger to update TABLE 2 with TABLE 1 updates
Searching with multiple keywords
Domains and updating a table based on the master table
VARCHAR2 vs. VARCHAR vs. CHAR
Using JDBC to access a DB2 database
Avoiding ORA-27038 when creating a tablespace in 8i
Are hyphens allowed in standard SQL column names?
Importing a SQL Server table into Oracle
How to retrieve a DB2 date in Julian format
Exporting a table to a lower version
When does OSUSER in V$SESSION = Oracle?
Comparing two tables
Preventing duplicate entries on multiple columns
Wide or deep?
Nested tables in MySQL
One query to return disjoint sets (MySQL)
Find duplicate sets of child rows
Summing across columns
One-to-one-or-more relationships, revisited
Is Visual FoxPro a flat database?
Merging hotels and data
Basic three-table join with a condition
Creating a purchase form for a hospital database
Duties of senior DBA versus developer
Sending queried data from the Web to a CSV or Excel file
Batch processing cpio -r
Which query is better?
DBAs and scripting languages
Sort order of composite primary keys
Changing an Access function to work in Oracle
Accepting the ' character in searches
Migrating Access and FoxPro data to Oracle
More on VARCHAR2 versus VARCHAR
Linking a Web page submit button to the database
Resolving the ORA-01034 error
Can Oracle and SQL Server run alongside one another?
Migrating Access and FoxPro data to Oracle 8
Capturing LOGON events in 7.3
Passing data as column names to another table
What is stored in the redo log?
Frontend Access abends between table accesses
What is the default tablespace?
Speedier way to open cursors?
The tim field explained
Copying an 8i database to another PC
Stopping users from doing specific commands in SQL*Plus
Restoring default database in 8i
Sending values from 7.3 to 8i
Practicing 8i OCP questions
Mutating table error with on delete cascade trigger
Including headings in stored procedure output
Restoring Oracle 7 from a cold backup
Resources for resolving TNS-00510 errors
Altering tables during an export
Pros and cons of auditing logon
Viewing the database through a Web browser
Accessing Oracle from Crystal Reports
Problems with nls_language
Sending information from the database to a pager
Storing only time, not date
Steps to copy an 8i database to another PC
REF cursors explained
VARCHAR2 versus VARCHAR
Error viewing records in table that has abstract column datatype
Killing the session through an AFTER LOGON trigger
Left and right joins explained
Loading data from Oracle into flat files
Bypassing the startup password in 8i
Problem getting tables from DB2 to 8i through ODBC
Converting times to a different time zone
Transferring data from Oracle to DB2
Why are DBAs ignoring my data model?
RAID and multiplexing
Creating a 600MB table in a 600MB tablespace
What happens when ARCH writers are writing the archive logs?
The largest SQL statement that Oracle can process
Flat file versus relational databases
Why use abstraction?
Creating a random value for the primary key
One consolidated schema or four separate ones for each app?
Post-relational and multidimensional databases critqued
Avoiding overhead of insert/delete with indexes
Joining tables that have composite primary keys
Using SSADM and DSDM for rapid application development
Creating a directory
Quotas and system performance
Automatically translating Gregorian and Hajrii dates
Getting SID and SERIAL# without V_$SESSION
Resolving the ORA-12505 TNS error
What is "=>" used for in PL/SQL?
PL/SQL UTL_SMTP procedure to send e-mail
High-level documentation on differences between 8i and 9i
Getting alternate rows from a table
Error trying to rebuild index after cancelled transaction
What is too high of a cardinality for a bitmap index?
Retrieving unique values from columns in one query
Populating the MODULE column of V$SESSION
Implications of REMOTE_OS_AUTHENT = true