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