DELETE or UPDATE, CASCADE or RESTRICT, part 2
Averages over a span of years -- Part 1
Hybrid databases explained
Merging customer lists
Deleting statistics after analyzing tables
Optimizer not using indexes
Pinning and caching
Remotely closing a D2K form
Insert without a column list
Storing multimedia data
Modeling tools that support DB2 and forward/reverse engineering
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
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
Creating a view from a 3-table join
Loading LONG RAW data
Can't open .dmp file
How to upgrade to 8.1.7
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
Which components are installed in the database?
Is a DOS platform database required to store huge amounts of data?
SQL versus stored procedures
When to build the data warehouse: before or after designing application database?
Logging failed trigger, automatically trying again
"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
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
Setting up automatic e-mail notification of expiring passwords
Migrating from Sybase to Oracle with SQL*Loader
Oracle licensing explained
Error using JDBC to query local database
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
Updating a table with values from another
Textcopy.exe and Oracle 8i
Grouping on the date part of a datetime column
Inserting three columns into one
SAN and cluster file systems
Purpose of a primary key
Exactly one row? At least one row? (Part 2)
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?
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
Using FTP to transfer text files spooled from an SQL statement
Creating ODBC applications
Inserting one million rows
Extracting processes taking longer and longer
Questions about procedures, packages and functions
Updating two different databases with the SQL UPDATE method
What to do as the only Oracle DBA in the company
A data-driven solution to changing expression when criteria change
New or composite primary key for a composite table?
Objects feature not enabled