Most frequently occuring problems in Oracle
Date column as primary key, part 2
Joining a table to one of two other tables
Parameter in INIT.ORA for cascading triggers
Oracle in the OLTP environment
Latest updated time value per group of rows
Choosing a database for use in an OLTP environment
What is Oracle Gateway?
Ordering of rows or columns in a relational table
Multiple outer joins
Outer join types
What is the role of a cluster?
C and the UNION clause
AFTER vs. BEFORE triggers
Passing parameters to a trigger
Stripping the first three characters off a column
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
Comparing one set of rows with another
Referencing rows by row number
Reporting duplicate names with non-null addresses
Combining invoice records
Using LIKE to return related keywords
DW vs. DBMS vs. data mining
Quote marks in queries
Changing SQL based on the status of visual controls
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
This year's versus last year's sales, Part II
Query to select top five rows in descending order
Number of unique key constraints
Value of SHMMAX
Time it takes to export databases
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?
Subselect from DUAL not giving an error
Remote database connection
Data driven occurs and the control file
Concatenating a literal in Microsoft Access
Importing/Exporting selected tables
Kernel parameters setting
Table-driven deletes and updates
Show the first three records of my table
Date column as primary key
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?
Running number in query results
Forms server for Oracle applications
Top 5 salaried employees, not using TOP
Table join sequence for performance
Latest date/time before current date/time
Mutating tables and AUTOCOMMIT
Executing external .sql files from stored procedures
What are the advantages of having a multi-dimensional database in data warehousing solution?
Generating an ascii delimited file
Oracle vs. Microsoft Access
Informatica and rollback segments
What does this theta self-join mean?
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
What should I do to take up a career in data warehousing?
Tips for the ETL tool evaluation and comparison process
How do other DW teams deal with in-and-out flows?
Do you need a data warehouse when you have a single dimension?
Insert statement process explanation
Is it possible to incorporate a compress/uncompress utility into a SQL query?
More detailed answer for Oracle Transparent Gateways for Informix 7.3
Oracle 8i DBA certification or 9i?
Explanation of code for deleting audit files
Migration with Oracle Transparent Gateways
Whether to use stored procedures or embedded SQL
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
Two columns in v$filestat
Inserting a blob field in SQL*Plus
Deleting physical datafiles from inside Oracle8i
How to keep data in an Oracle8i database before sending it to an external historical database?
Novice server advice for creating Web portal site
Access command button to cancel an Add New Record