For more information about the site, see the Site Index

• Tracking DDL activities in Audit Trail
• Assigning output with special values
• Refreshing one 8.0.5 instance's data with another
• Copying a word in a purchase order to three other lines
• Creating referential integrity with constraints or triggers
• Getting the MAX over a partition
• Backing up a 2.2 TB database
• Workaround for the ORA-4091 error when checking ranges
• Getting hard disk serial numbers through Oracle?
• Disabling and enabling triggers
• Sybase and SQL Server programmer having trouble with Oracle SQL
• Functions of the SGA components
• Accessing the database using XML
• Calculating the initial extents of a table
• Practicing Oracle commands online
• The 9.2.0.2 patchset: Migration or upgrade?
• Setting up the initial configuration for a database
• Is analysis of indexes redundant if data unchanged?
• Determining the problem from the error message
• Resovling the ORA-6401 error
• Trigger to restrict user after a certain number of logons
• Setting up Oracle in a two-node environment
• Sorting rows randomly
• Problems connecting to Developer and using backup wizard
• Alphanumeric primary key
• Composite primary keys and indexes
• What happens to data dictionary and system tables during upgrade
• Capturing the before and after images of data with triggers
• Database link works for a few days, then ORA-12640
• Calculating next extent size
• Error trying to recreate nonsystem control file
• Ordering nulls first, then numbers starting at 0
• Group aggregates as fractions of overall aggregate
• Looking for Oracle 8.1.7.0.0 for HP-UX 11.0
• OUTER JOIN instead of a NOT EXISTS subquery
• Inserting values from one table into another, with another set of values
• The recursive relationship
• Executing backup and restore scripts from another application
• Known issues with W2K sp2 and sp3 with Oracle 8.1.7
• Running large inserts without rollback errors
• SELECT statement showing up incorrectly at the beginning of the flat file
• Replication of three remote locations
• Splitting number ranges
• Where should the summary tables be used?
• Loading updated schema from test to production
• Calculating weeks between two dates
• More on defragmenting a tablespace to free space
• How to validate zip code, city, and state code
• What is the file extension of an Oracle database?
• Full outer join in a many-to-many relationship, part 2
• Full outer join in a many-to-many relationship, part 1
• Orphan composite foreign keys
• Can a trigger add rows to triggering table?
• Searching for NULL values
• Moving T-SQL stored procedures to PL/SQL or Java
• Importing data from a dump file more than one time
• Checking status of a database that has no documentation
• What values can be deduced from sys.dual?
• X$KGLOB not visible
• Updating FoxPro fields with Oracle data
• More on the OSUSER value
• Getting database response times
• Are left outer joins messing up the optimizer?
• Migrating data from DB2 to 9i
• Oracle training courses specifically for SQL Server professionals
• Query of a view returning repeating records
• Defragmenting a tablespace to free up contiguous space?
• How to read dump files
• Best way to migrate 8.0.5 to 8i or 9i
• Query execution slower with indexes
• Inserting all new data at one time, not individually
• Starting a data warehouse
• Does Oracle log disconnections?
• Shipping archive logs automatically
• Replicating database on different servers
• Storing .pdf files inthe database
• Error connecting Forms Builder to database
• Viewing log files on version 7.3.3 on OS/390
• Writing a Java tool to analyze redo log file
• Storing video clips
• Updating all forms with a new server path
• Problem using imp/exp function from OMS
• Importing a SQL Server table into Oracle
• Are hyphens allowed in standard SQL column names?
• Avoiding ORA-27038 when creating a tablespace in 8i
• When does OSUSER in V$SESSION = Oracle?
• Trigger to update TABLE 2 with TABLE 1 updates
• Searching with multiple keywords
• VARCHAR2 vs. VARCHAR vs. CHAR
• Domains and updating a table based on the master table
• SID explained
• Inserting the '&' symbol in a string
• How much memory will Oracle use?
• Problem connecting to a remote database
• Delete install directories after installation?
• Dumping LOB columns into another table
• How to retrieve a DB2 date in Julian format
• Adding a new NOT NULL field to an existing table
• Calculating the initial extents
• Exporting a table to a lower version



• More