For more information about the site, see the
Day of the week
Installing Informatica and Oracle on same system
Deleting statistics after analyzing tables
Age constraint on a date column
Hybrid databases explained
Merging customer lists
Insert without a column list
Pinning and caching
Remotely closing a D2K form
Optimizer not using indexes
Storing multimedia data
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
Time-based stored procedure to check table and update old records
Migrate/copy database to another server
PL/SQL functions returning a string longer than 32767
Reading Reports 3.0 .pdfs without the PDF Writer/Distiller
Triggers not working after export from user X to user Y
Creating a view from a 3-table join
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
Which components are installed in the database?
Paging without running a query a second time?
Starting instance automatically on W2K
Using Table 2 values for Table 1 when column names are the same
Important configuration parameters for Oracle on Solaris
Cube and vertical partitioning explained
Transactions per second in 8.1.7
Total size of SGA greater than what was allocated
When to build the data warehouse: before or after designing application database?
SQL versus stored procedures
Logging failed trigger, automatically trying again
"mydatabase" and database links
Is a DOS platform database required to store huge amounts of data?
Can't open .dmp file
How to upgrade to 8.1.7
Loading LONG RAW data
Importing data into different tablespace with a different user name
Oracle9i as a CAD database
Query to find size of BLOB objects
Root script logging in as system then altering password: bad practice?
Where session-specific SQL is executed
Separating 8i, 9i listeners installed on same machine
Strategies for data backup for terabytes of data
Determining instances for a data mart
Scheduling a query
Problem installing Oracle on Red Hat Linux
AS versus IS
Many-to-many links that aren't there
Paging through a result set without TOP or LIMIT
Grouping output by week
Inserting multiple child rows
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
Oracle licensing explained
Error using JDBC to query local database
Changing the datatype of a column in 8.1.7
Why isn't my cursor returning any rows?
Why logs shouldn't be put on RAID devices
Aggregates with associated detail values
Textcopy.exe and Oracle 8i
Cleaning up older Oracle stuff before upgrading
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
Updating a table with values from another
Uploading an Excel file into the database
Purpose of a primary key
Inserting three columns into one
What does SELECT 1 accomplish?
Exactly one row? At least one row? (Part 1)
What version of HP-UX is the best for Oracle 9i/Oracle 9iAS?
SAN and cluster file systems
Exactly one row? At least one row? (Part 2)
Grouping on the date part of a datetime column
Setting up a recovery catalog
Using DISTINCT on two fields
Listener could not solve the SID given in connect descriptor
When is temporary tablespace used?
Trigger to restrict number of rows in a table
Importing a dump file from a higher version
New or composite primary key for a composite table?
Loading text files into Oracle tables
Objects feature not enabled
Need to worry about datafiles when upgrading OS?
Inserting one million rows
Extracting processes taking longer and longer
Questions about procedures, packages and functions
Using FTP to transfer text files spooled from an SQL statement
Creating ODBC applications
Starting archive log mode