For more information about the site, see the
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 126.96.36.199 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 188.8.131.52.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
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