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