Age constraint on a date column
Design for sales database
Hybrid databases explained
Merging customer lists
Deleting statistics after analyzing tables
Pinning and caching
Remotely closing a D2K form
Optimizer not using indexes
Storing multimedia data
Insert without a column list
Reading Reports 3.0 .pdfs without the PDF Writer/Distiller
Triggers not working after export from user X to user Y
Migrate/copy database to another server
PL/SQL functions returning a string longer than 32767
Time-based stored procedure to check table and update old records
Getting a row number in a group
Should unrelated data marts be on the same instance?
Scripts for NT to delete archived Oracle scripts
Modeling tools that support DB2 and forward/reverse engineering
Can I write code using VB editor to query MS Excel VBA?
Tool to transfer DB objects from Oracle 8i to SQL Server
Deadlocks occuring when many transactions on same tables occur simultaneously
Creating a view from a 3-table join
Cube and vertical partitioning explained
Using Table 2 values for Table 1 when column names are the same
Total size of SGA greater than what was allocated
Important configuration parameters for Oracle on Solaris
SQL versus stored procedures
Logging failed trigger, automatically trying again
When to build the data warehouse: before or after designing application database?
Loading LONG RAW data
Can't open .dmp file
How to upgrade to 8.1.7
Which components are installed in the database?
Is a DOS platform database required to store huge amounts of data?
"mydatabase" and database links
Transactions per second in 8.1.7
Paging without running a query a second time?
Starting instance automatically on W2K
Oracle9i as a CAD database
Where session-specific SQL is executed
Query to find size of BLOB objects
Root script logging in as system then altering password: bad practice?
Importing data into different tablespace with a different user name
Separating 8i, 9i listeners installed on same machine
Determining instances for a data mart
Scheduling a query
Strategies for data backup for terabytes of data
AS versus IS
Problem installing Oracle on Red Hat Linux
Paging through a result set without TOP or LIMIT
Grouping output by week
Inserting multiple child rows
Many-to-many links that aren't there
Migrating from Sybase to Oracle with SQL*Loader
Finding users and their network addresses
Error with tnsping test
Setting up automatic e-mail notification of expiring passwords
Error using JDBC to query local database
Oracle licensing explained
Cleaning up older Oracle stuff before upgrading
Why isn't my cursor returning any rows?
Why logs shouldn't be put on RAID devices
Oracle equivalent of LIMIT and OFFSET to get nth row
Months between two dates in Oracle
Exporting table in a ebcdic character set and comp-3 format
Importing and exporting a database from a remote machine
Aggregates with associated detail values
Changing the datatype of a column in 8.1.7
Uploading an Excel file into the database
Textcopy.exe and Oracle 8i
Updating a table with values from another
Grouping on the date part of a datetime column
Inserting three columns into one
What does SELECT 1 accomplish?
Exactly one row? At least one row? (Part 2)
SAN and cluster file systems
Purpose of a primary key
What version of HP-UX is the best for Oracle 9i/Oracle 9iAS?
Exactly one row? At least one row? (Part 1)
Setting up a recovery catalog
Using DISTINCT on two fields
Listener could not solve the SID given in connect descriptor
Importing a dump file from a higher version
Inserting one million rows
Extracting processes taking longer and longer
Questions about procedures, packages and functions
Loading text files into Oracle tables
When is temporary tablespace used?
Trigger to restrict number of rows in a table
Updating two different databases with the SQL UPDATE method
Using FTP to transfer text files spooled from an SQL statement
Creating ODBC applications
A data-driven solution to changing expression when criteria change
What to do as the only Oracle DBA in the company
Objects feature not enabled
Need to worry about datafiles when upgrading OS?