Host string for a typical Oracle installation
Date column as primary key, part 2
Most frequently occuring problems in Oracle
Choosing a database for use in an OLTP environment
Oracle in the OLTP environment
Joining a table to one of two other tables
Parameter in INIT.ORA for cascading triggers
Latest updated time value per group of rows
What is Oracle Gateway?
What is the role of a cluster?
C and the UNION clause
Passing parameters to a trigger
AFTER vs. BEFORE triggers
Multiple outer joins
Outer join types
Ordering of rows or columns in a relational table
Using LIKE to return related keywords
DW vs. DBMS vs. data mining
Quote marks in queries
Adding and subtracting in inner joins
Concatenation and field lengths
Hierarchy support in Oracle and SQL Server
Views vs. the WHERE clause
Architecture for the real estate industry
Resources for beginners
Tiers and data marts
Changing SQL based on the status of visual controls
Query to select top five rows in descending order
Row sums and the "totals" row
Key factors for successful SQL
This year's versus last year's sales, Part I
Extracting a part number from a text field
Referencing rows by row number
Reporting duplicate names with non-null addresses
Comparing one set of rows with another
Stripping the first three characters off a column
This year's versus last year's sales, Part II
Combining invoice records
Number of unique key constraints
Time it takes to export databases
Value of SHMMAX
Importing a file into your database
Oracle on AutoRaid information
Copying an Oracle database
Setting up memory window for each database instance in Oracle Apps 11.03
Virtual memory segment in Informix
Log file to check WAN/LAN use and checking server hard disks
Sizing a HP-UX server for Oracle Parallel Server
How many Oracle IDs/passwords should we have for one data warehouse?
Three leading ETL products a global organization should consider
Can you use ETL successfully as part of the process to migrate from OS/390 to Unix or NT?
Remote database connection
Importing/Exporting selected tables
Data driven occurs and the control file
Subselect from DUAL not giving an error
Concatenating a literal in Microsoft Access
Kernel parameters setting
Date column as primary key
Table-driven deletes and updates
Show the first three records of my table
Can I use IBM data load software to migrate Tandem DB to UDB?
Are you aware of any customized data warehousing solution for strategic/centralized sourcing?
How do I get management to sponsor our EIS project?
Forms server for Oracle applications
Top 5 salaried employees, not using TOP
Running number in query results
Oracle vs. Microsoft Access
Informatica and rollback segments
Executing external .sql files from stored procedures
Mutating tables and AUTOCOMMIT
Generating an ascii delimited file
What does this theta self-join mean?
What are the advantages of having a multi-dimensional database in data warehousing solution?
Table join sequence for performance
Latest date/time before current date/time
How do folks deal with data that has no 'true' application within the enterprise?
What factors should we consider to improve the performance of loading?
Can a workflow-driven business process help to manage reference data on both SAP and Siebel?
How can I integrate my data warehouse into the Web?
Oracle database on raw volumes
Tips for the ETL tool evaluation and comparison process
What should I do to take up a career in data warehousing?
How do other DW teams deal with in-and-out flows?
Do you need a data warehouse when you have a single dimension?
More detailed answer for Oracle Transparent Gateways for Informix 7.3
Insert statement process explanation
Is it possible to incorporate a compress/uncompress utility into a SQL query?
Oracle 8i DBA certification or 9i?
Explanation of code for deleting audit files
Two columns in v$filestat
Inserting a blob field in SQL*Plus
Is there a way to allow just (client) users from a certain domain to connect to the database?
Best way to determine if an index is being used
Deleting physical datafiles from inside Oracle8i
Whether to use stored procedures or embedded SQL
Migration with Oracle Transparent Gateways
How to keep data in an Oracle8i database before sending it to an external historical database?
Novice server advice for creating Web portal site