DELETE or UPDATE, CASCADE or RESTRICT, part 2
Averages over a span of years -- Part 1
Merging customer lists
Deleting statistics after analyzing tables
Hybrid databases explained
Storing multimedia data
Insert without a column list
Optimizer not using indexes
Pinning and caching
Remotely closing a D2K form
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
Deadlocks occuring when many transactions on same tables occur simultaneously
Can I write code using VB editor to query MS Excel VBA?
Tool to transfer DB objects from Oracle 8i to SQL Server
Time-based stored procedure to check table and update old records
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
Creating a view from a 3-table join
SQL versus stored procedures
When to build the data warehouse: before or after designing application database?
Logging failed trigger, automatically trying again
Is a DOS platform database required to store huge amounts of data?
Can't open .dmp file
How to upgrade to 8.1.7
Which components are installed in the database?
Loading LONG RAW data
Total size of SGA greater than what was allocated
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
"mydatabase" and database links
Transactions per second in 8.1.7
Paging without running a query a second time?
Starting instance automatically on W2K
Where session-specific SQL is executed
Oracle9i as a CAD database
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
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
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
Oracle licensing explained
Error using JDBC to query local database
Setting up automatic e-mail notification of expiring passwords
Migrating from Sybase to Oracle with SQL*Loader
Finding users and their network addresses
Error with tnsping test
Uploading an Excel file into the database
Why isn't my cursor returning any rows?
Why logs shouldn't be put on RAID devices
Cleaning up older Oracle stuff before upgrading
Changing the datatype of a column in 8.1.7
Aggregates with associated detail values
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
Textcopy.exe and Oracle 8i
Updating a table with values from another
Grouping on the date part of a datetime column
Purpose of a primary key
SAN and cluster file systems
What does SELECT 1 accomplish?
Exactly one row? At least one row? (Part 2)
Inserting three columns into one
Exactly one row? At least one row? (Part 1)
What version of HP-UX is the best for Oracle 9i/Oracle 9iAS?
Creating ODBC applications
Using FTP to transfer text files spooled from an SQL statement
Updating two different databases with the SQL UPDATE method
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
Loading text files into Oracle tables
Inserting one million rows
Extracting processes taking longer and longer
Questions about procedures, packages and functions
What to do as the only Oracle DBA in the company
A data-driven solution to changing expression when criteria change
Objects feature not enabled
Need to worry about datafiles when upgrading OS?