Calling a PL/SQL procedure
Automatically dropping temporary tables
Calculating the initial extents
Are hyphens allowed in standard SQL column names?
Trigger to update TABLE 2 with TABLE 1 updates
Searching with multiple keywords
VARCHAR2 vs. VARCHAR vs. CHAR
Using JDBC to access a DB2 database
How to retrieve a DB2 date in Julian format
Exporting a table to a lower version
When does OSUSER in V$SESSION = Oracle?
Preventing duplicate entries on multiple columns
Comparing two tables
Wide or deep?
One-to-one-or-more relationships, revisited
Nested tables in MySQL
One query to return disjoint sets (MySQL)
Find duplicate sets of child rows
Summing across columns
Merging hotels and data
Is Visual FoxPro a flat database?
Basic three-table join with a condition
Creating a purchase form for a hospital database
More on VARCHAR2 versus VARCHAR
Migrating Access and FoxPro data to Oracle
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
Linking a Web page submit button to the database
Resolving the ORA-01034 error
Can Oracle and SQL Server run alongside one another?
Stopping users from doing specific commands in SQL*Plus
Restoring default database in 8i
Sending values from 7.3 to 8i
Copying an 8i database to another PC
Migrating Access and FoxPro data to Oracle 8
Capturing LOGON events in 7.3
Passing data as column names to another table
What is the default tablespace?
What is stored in the redo log?
Frontend Access abends between table accesses
Speedier way to open cursors?
The tim field explained
Practicing 8i OCP questions
Mutating table error with on delete cascade trigger
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
Accessing Oracle from Crystal Reports
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
Viewing the database through a Web browser
Pros and cons of auditing logon
Including headings in stored procedure output
Restoring Oracle 7 from a cold backup
Resources for resolving TNS-00510 errors
Altering tables during an export
Problems with nls_language
Converting times to a different time zone
Transferring data from Oracle to DB2
Why are DBAs ignoring my data model?
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
RAID and multiplexing
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
PL/SQL UTL_SMTP procedure to send e-mail
Getting SID and SERIAL# without V_$SESSION
Resolving the ORA-12505 TNS error
Quotas and system performance
Automatically translating Gregorian and Hajrii dates
What is "=>" used for in PL/SQL?
Creating a directory
High-level documentation on differences between 8i and 9i
Getting alternate rows from a table
Best way to restrict user access to columns in a table
Incremental export of a table?
Trigger to populate the date field on a table being updated
Setting up replication between two databases