For more information about the site, see the Site Index

• Knowing when a checkpoint has completed
• Oracle's security features
• Populating one name column from three
• Selecting the latest order for a customer
• Copying an entire table to another table
• Books about data warehousing
• Benefits and drawbacks to data warehouses
• Keeping current with data warehousing news
• Updating fact tables while loading the data warehouse
• Who are the big players in data warehousing?
• Building a human resources data warehouse
• Calculating quartiles
• Displaying time ranges based on login, logout
• Copying and pasting a row in the same table
• Future developments for data warehouses
• Showing results as a percentage
• Selecting fractions of a penny
• A Master/Detail report using SQL
• Are COUNT and DISTINCT SQL-92 compliant?
• Sorting the days of the week with Monday first
• Crosstab sales by year
• Invoice amounts in a Crystal report
• Sybase vs. Oracle vs. SQL Server 2000
• Can star schemas do it all?
• Selecting all "John"s
• Finding and deleting duplicate records in a table
• Listing sales agent with highest total by month
• Establishing referential integrity
• Selecting from two tables: eliminating duplicates, but summing quantities
• Finding flights without regard to number of stops
• Comparing values in different rows
• Trigger to populate name field with uppercased and rtrimmed version of user entry
• Concurrency in an OLTP environment
• Joining tables without JOIN or subqueries
• Creating a relationship between different tables and databases
• Advice for becoming an Oracle application developer
• Coding a MEMBER FUNCTION
• Trouble with TRUNCATE in a procedure
• Returning zero when requested time period has no data
• Calculating running totals in SQL
• Using SQL to access tree branches
• Returning data when requested time period has no data, part 2
• Details of varchar2 in the DBMS vs. PL/SQL
• Query for finding duplicate clients in the database
• Installing Developer 6i and database 8 together
• Can Informatica import metadata from some other ETL tool?
• Databases on RAID 5 devices, part 2
• Resetting databases for testing purposes
• Diagnosing performance problems
• What is tuple?
• TEMP tablespace, but no TEMP.dbf file
• The v$process table explained
• The pros and cons of UNION
• Resolving the ORA-1630 error
• How writers do not block readers in Oracle
• Oracle back end with a C++ front end?
• The easiest way to back up and restore Oracle 8
• Creating a new user in Oracle
• Bug in exporting wrapped procedures in Oracle 8.1.7.2
• Incremental backup explained
• Controlling access to Oracle with LDAP
• Installing Oracle 9i and SQL Server 2000 on the same hard disk
• Removing a column from a table
• Designing a database to support a tree structure
• How large can lookup tables be?
• Need help to learn SQL
• Extracting the highest record in a group
• Need help to develop queries
• Efficient selection of "all" rows
• Error starting listener Oracle 8i on Win98
• Catching, modifying SQL and results between Discoverer and Oracle
• Linux or Windows 2000?
• Database instance and listener explained
• Ratio of user calls to recursive calls explained
• Precompilers explained
• Installing Oracle 8i in Win98
• Creating and changing passwords to connect
• Application development: PL/SQL, Java or C++?
• Selecting the entry with the highest numerical value
• How Oracle handles concurrent queries
• Deleting one field in a table and changing fonts in reports
• Foreign keys and triggers for referential integrity explained
• Deleting 4000 rows from a table at once
• Recovering a crashed database
• Relational databases for office information systems
• Connecting database of users' scores on a games Web site
• Adding reviews to a database of books and authors
• Using foreign key to associate managers and employees
• Utility to trace SQL (like Microsoft's SQL Profiler)
• Converting a character column containing dates to a DATE column in Oracle
• What is a primary key? Composite PK? Foreign key? Tuple?
• Using ISNULL or NULLIF to prevent division by zero
• MS Access, MS SQL Server and Oracle compared
• Joining tables based on partial matches
• Data warehousing in Oracle
• Checking table updates: who, when
• Sequences and indexes explained
• Translating Oracle SQL to Microsoft SQL
• Calculating percentiles in SQL
• How does WHERE EXISTS ( SELECT NULL... ) work?



• More