Are hyphens allowed in standard SQL column names?
Avoiding ORA-27038 when creating a tablespace in 8i
Using JDBC to access a DB2 database
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
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
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?
Sending values from 7.3 to 8i
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
Restoring default database in 8i
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
Practicing 8i OCP questions
Mutating table error with on delete cascade trigger
Restoring Oracle 7 from a cold backup
Resources for resolving TNS-00510 errors
Including headings in stored procedure output
Altering tables during an export
Accessing Oracle from Crystal Reports
Converting times to a different time zone
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
Pros and cons of auditing logon
Viewing the database through a Web browser
Problem getting tables from DB2 to 8i through ODBC
Problems with nls_language
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
Why use abstraction?
Flat file versus relational databases
One consolidated schema or four separate ones for each app?
Post-relational and multidimensional databases critqued
Avoiding overhead of insert/delete with indexes
Creating a random value for the primary key
Joining tables that have composite primary keys
Using SSADM and DSDM for rapid application development
PL/SQL UTL_SMTP procedure to send e-mail
What is "=>" used for in PL/SQL?
Resolving the ORA-12505 TNS error
Creating a directory
Quotas and system performance
Automatically translating Gregorian and Hajrii dates
Getting SID and SERIAL# without V_$SESSION
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