For more information about the site, see the Site Index
- Best way to load 500,000 rows every hour
- Restriciting all access to database during a particular time
- Checking if varchar2 column contains only numbers
- Dropping and recreating rollback segments to avoid error
- Resolving error ORA-06550
- Searching through the conent of stored procedures
- Triggers to encrypt/decrypt code
- Maximun number of columns for a composite primary key
- SQL statement to return primary keys
- Security holes opened by logging on with 'as sysdba'
- Are we following the right backup procedure?
- Deconcatenating a field
- Transferring data in one table between schemas
- Separating object into two schemas in same instance
- Not able to remove duplicate rows
- Capturing errors from MERGE statement
- Making a test server with IMPORT/EXPORT
- Where are RMAN scripts kept?
- Catching error code that arises in PL/SQL
- More on logging the command that caused error
- Converting LONGRAW to BLOB
- Limiting number of rows returned by query
- Analyzing and monitoring performance, disk space, etc.
- Getting invalid column name without access to system tables
- Uninstalled services still showing up in Win2000
- Stopping everyday message in alert.log file
- Ideal maximum size for datafiles
- Using Julian date to convert numbers to words
- Resolving the "The instance Oracle VTDBS has been Terminated" error
- Executing an OS command through a stored procedure
- When to use functions and stored procedures
- Other ways to call variable name packages
- Updating an open cursor
- Select statement coming back as null, even though value is in CHAR column
- Will tablespace show more free space after deleting records?
- Replicating test database to production
- Running SQL*Loader from within PL/SQL procedure
- Retrieving the second row inserted
- AFTER LOGON trigger doesn't fire after migration
- Resolving the TNS-12502 error
- Query fast on SQL Server, slow on Oracle
- Understanding and working with database file extensions
- Optimizing a COUNT query
- Can a table have two primary keys?
- ON DELETE SET NULL for lookup tables
- Row calculations using a derived table
- Transposing rows and columns in a SELECT statement
- Logging the sql_text on update/insert/delete in trigger
- Utilizing two processors evenly
- Why can't size of primary key exceed one database block?
- Calling variable name packages
- SYS versus SYSTEM users
- Setting up Oracle as case insensitive
- Sequence of user process, server process, instance and session
- Installing the OCI client
- Optimizing Oracle 8.0.5 on Windows 2000
- Resolving ORA-12560 error
- Dropping columns
- Tablespace still has 80% usage after large deletion
- Synchronizing primary and standby databases
- Error after installing MP2
- Restoring RMAN backups to a different server
- 'Updateable Snapshots' and Oracle 9i Standard Edition
- Changes to make when migrating from 7 to 8i
- 30-day limit on evaluation CD packs from Oracle
- Using DEINSTALL_LIST={"component1","1.0.1.2"} to deinstall a component
- Resolving an IMP-00002 error
- Using SQLLDR, EXPORT and IMPORT from a client machine
- Recovering a database on another machine
- Obtaining an Oracle poster
- ON DELETE in a many-to-many relationship
- Calling a PL/SQL procedure or function from a Java program
- FETCH FIRST n ROWS ONLY functionality in Oracle
- Oracle.exe taking 99% of CPU
- Table comparison stored procedure very slow
- Binary_integers and indexes
- Rebuilding tablespaces
- Placing frequently accessed data on outer edge of disk drive
- Error with new_empno variable
- Resolving errors ORA-01652 and ORA-04031
- Errors when running catalog.sql and catproc.sql files
- Sending email from a stored procedure or trigger
- How to drop the example schemas from Oracle9i
- Restricting user exports
- Counts from two different tables in one query
- Performing INSERT calculations
- Format query output as header and detail lines
- Details of UNDO space, restricitng transaction usage
- Integrating MySQL into Oracle
- Benefits, costs of running RAC
- User datafile needs media recovery
- Using DECODE to display invoice balances by due date
- Cloning an instance on the same server
- SQL Server and Oracle connectivity error
- Progress versus Oracle DBAs
- Installation error: Java Runtime Environment not found
- Calling a stored procedure from a trigger
- NULL OR TRUE evaluates as TRUE
- Analyzing stagnant databases
- Data dictionary versus the data directory
- More