For more information about the site, see the Site Index
- Help with AFTER SUSPEND trigger
- Solving error ORA-3113
- How to prevent unauthorized access to certain forms?
- What should monitoring reports identify
- Migrating Oracle between Linux and Windows NT
- What's a perpetual licensing policy?
- How far can 9iRAC be implemented using Fibre Channel?
- Oracle on Windows NT vs. Linux
- Transferring Oracle from Windows NT to Linux
- Resources for performance tuning and V$ views
- Top N subcategories, Part 2
- Top N subcategories, Part 3
- Top N subcategories
- Data warehousing for firing reports, continuing with OLTP
- Printing and capturing data in ASCII format
- Dates and DECODE
- Loading data into an Oracle database using SQL*Loader
- Dynamic SQL, part 2
- Updating stats using analyze statement
- Dynamic SQL, part 3
- Dynamic SQL, part 1
- Fiscal year, ISO week, part 1
- Fiscal year, ISO week, part 2
- Converting columns to rows
- ON DELETE and ON UPDATE on same table
- Need help with Oracle database replication
- Determining what patch level is needed
- 10g and the grid
- How to upgrade Standard to Enterprise Edition of Oracle 8.1.6
- Solving error ORA-12545
- Help with error ORA-01078
- What does an 11i DBA do that a 9i/8i DBA does not?
- Does Oracle work better on Windows or Unix/Linux?
- Substitution variables, part 2
- Substitution variables, part 1
- Top-N Subquery
- Integrating applications to reduce data maintenance, part 1
- Integrating applications to reduce data maintenance, part 2
- Views and table vs. column constraints
- Is Oracle on Linux compatible with Oracle on Unix?
- Triggers and spooling data
- Automating rollback segment handling
- Exporting financial information
- Uninstalling Oracle9i
- How to protect Oracle 9.2 from virus
- Tuning database recovery
- Oracle on Windows vs. Linux
- How to translate error message to English
- Counting days in 11i report
- Program manager certification programs
- Testing for holidays, part 2
- Testing for holidays, part 1
- Cycle relationships in ER diagram?
- Logical and physical data models explained
- Help with 11.5.8 install on HP Tru64
- Integrating Oracle apps with a wireless network
- How to find source code
- Calculating approval date, part 2: A faster day counter
- Calculating approval date, part 1: Counting days
- Calculating approval date, part 3: Code for a faster day counter
- Selecting non-NULL values, part 2
- Automatically discovering Linux nodes
- What's an Oracle instance?
- Documentation for Oracle 8.0.5 Workgroup on Windows
- Installing Oracle8i on Developer6i
- Formulas for sizing estimation
- How to determine what's happening in redo logs
- Creating control files
- Migrating from FoxPro to Oracle
- Finding which objects are being hit hardest in I/O
- Ordering data loads
- Checking frequency of full table scans
- Picking the first 25 characters in SQL
- Getting up to speed on Oracle
- Syntax differences in MS Access
- Three ways to query a table relationship
- Combining a LEFT OUTER and INNER join
- SQL vs. PL/SQL
- Selecting non-NULL values
- UNION in a subquery
- Summing values in discrete ranges
- Extracting leading numeric digits from a field
- A view for a MAX value in any month
- Fixing duplicate primary keys
- One table or two tables with a join?
- Foreign key must reference a unique key
- How Oracle works with WindowsNT
- Creating DDL to drop tables
- The Sybase list() aggregate function
- Sources for MOLAP vs. ROLAP, R-cubes
- Table design in OLAP versus OLTP
- MI, CI and BI
- Counting number of transactions in a variable time
- Showing one line per patient per day with GROUP BY
- Showing one line per patient per day with GROUP BY, part 2
- Redesigning product dimension columns in database for datamart
- File loading suddenly slow in Informatica
- Calculating initial, next and max extents
- What happens in background when in hot backup mode
- Settings for JAVA_POOL_SIZE
- More