Starting archive log mode
New or composite primary key for a composite table?
Business user involved with data warehouse project
Deciding between type 1 and type 2 dimensions
Inserting a carriage return in an Oracle table
Mutating table error with "NEW" bind variable
Query to get user information
Looking for info on Sybase PowerStage and PowerDimension tools
Can we estimate maximum rate data can be loaded?
Column names in a UNION
Aggregates for date ranges
Break down dollars into number of bills
Finding the sequence of the last full backup
Max within a subset
Passing query in stored procedure to cursor variable
8i versus 9i with respect to code changes in applications
Size of extents with AUTOALLOCATE
Removing an instance and all associated tables, etc.
Upgrading to a newer release
Rights to views, not tables
Installing 9i: what you need to do
Aggregate functions in a left outer join
Last N rows in DB2
Creating an autonumber in Access using DDL
TOP 2 results in just one query
INSERT using values from another table
Closest date before or after a given date
DELETE using values from another table
Extracting a substring from a variable position in a string
Inserting/updating at the same time
Use column alias to query same field names
IN subquery or EXISTS subquery
Combining like tables
Updating a table by adding data from another table
Tool to migrate DB2 stored procedures to Oracle 8i
Guessing whether tablespace has sufficient space
Getting the SQL traffic byte size for session and transaction
Sending text messages to mobile when batch job completes
'RRRR' versus 'YYYY' in the date format
Character sets in SQL*Plus for Windows and for DOS
Saving time when logging in to SQL*Plus
Problem installing Oracle9i on WinXP Pro after failed 8i installation
Installing two versions of Oracle on the same box
Can there be more than one database in an Oracle instance?
Oracle vs. SQL Server revisited
More on exclusive OR subtypes
Tools to teach normalization
Candidate key explained
Recovering passwords for the DBA/SYS DBA schemas
Mapping time intervals with Oracle's date arithmetic
Uses for the Data Dictionary; redo logs and background processes explained
Does RAC require raw filesystems?
Replicating data between SQL Server 2000 and Oracle
Database link through port 80
Turning off functionality that converts number to char field
Number of open cursors increasing
Error trying to reduce TEMP tablespace back to default
Changing character sets
Is there a generic crosstab/pivot feature?
Using CASE to change SELECT column values
Last day of the month
Methods of depicting a data model
Selecting every 100th of 1,000,000 rows
What is the importance of query optimization?
What is the benefit of Oracle Replication?
Pros/cons of an Oracle 8i standby server?
Why should an OPS be implemented along with a standby server?
What is Oracle replication?
How can recovery be achieved in a commercial RDBMS?
How does concurrency control the scheme of DBMS?
Who are the top BI vendors in the international market?
Rapid application development, structured and soft sytems methods of design
Why use a "business key" and a "primary key"?
The significance of BCNF
Modeling an exclusive OR relationship
Can an Access expert easily begin developing in SQL Server?
Oracle8i features not found in MS SQL Server 2000
Deleting archive logs in Windows 2000
Can triggers be applied to sequence objects?
Tools for reverse engineering a database
Starting service from service window in admin tools
Copying tables from one DB to another via database link
Indexed views and Oracle
Error with public database link
Clustered and non-clustered indexes again
Composite foreign keys, Part 1
Composite foreign keys, Part 2
Running SQL*Plus scripts without supplying password
Finding rows with non-printable characters in them
8i versus 9i certification
Retrieving forgotten passwords for system user
Capturing all SQL statements issued by a user
Is it possible to separate archiving logs based on user?
Calculating a running sum
How can I tell what PFILE was used to start up Oracle?
RAID 3 or 5 for digital video storage
Loading Oracle onto Red Hat Linux
Parsing a delimited string