How to implement a ref cursor called in a stored procedure
Why am I getting the ORA-00381 error when initializing the parameter?
Performance issues in Oracle 9i
What is the difference between an instance and mounting in Oracle?
How can I solve the ORA-4030 error?
What is Unix shell scripting?
How to get history of modified data from Oracle databases
Performing a backup with table locks
Export dump with files larger than 2 GB
Benefits of a 3NF level of normalization
Moving a table with a LOB column
In Oracle, does the number of columns in a table affect the performance during SELECT/INSERT/UPDATE?
How does Oracle identify which password file to use?
Allocating bytes as extents in Oracle
How to move data faster with a database link
What is the difference between a production DBA and a developer?
Analyzing wait events in Oracle
Failed stored procedure through db link in Oracle
Creating db links from Oracle 10g to 8i
How do you size spatial tables and indexes?
Errors when importing from production to development
Can I export an Oracle database from UNIX and import to Windows?
Oracle upgrade basics
Import on one table from dump file
How do I retrieve second transaction for each customer?
Querying metadata and data at the same time
Correlated update in Oracle
Can I restrict data in a single schema?
When should an Oracle database be reorganized?
Recreating advanced queuing objects during database upgrade
How would referential integrity work in this situation?
Using Oracle's Virtual Private Database, aka Fine-Grained Access Control
How DDL and DML commands work in Oracle
Why am I getting the ORA-01195 error when issuing a recover command?
Oracle block size during import
Converting text data to an Oracle table without Oracle's SQL*Loader utility
Allowing NULL values
SGA sizing in Oracle
Moving Oracle binaries
Error during RMAN backup
Can I drop a column in SYS schema?
How to encrypt RMAN backups
A running total
SQL to update the header records?
SQL to round up to nearest thousand
How do you create a link between two databases inside a stored procedure?
How can I find statistics on total memory usage and database connections?
Should I port from Microsoft Access?
Installing multiple Oracle homes
STATSPACK tool: transaction vs. execution measurement
Redo log file problems
Can I resize SGA while the database is up and running?
Can I move a SYSTEM tablespace when the database is running?
RDBMS composite key definition
What are the main challenges when working with both Oracle 64 bit and 32 bit versions?
In Oracle Data Guard, which database is primary?
Manual upgrade vs. export and import
Offsite database replication
Modifying SYS password in a RAC environment
Defining Real Application Clusters (RAC) vs. Storage Area Network (SAN)
Why am I getting the ORA-02019 error?
When are changes recorded in the database buffer cache?
Should I store three spaces in this database field?
What is the ORA-03113 error?
Maximum limit Oracle DBMS datafiles
Changing the Database Identifier (DBID)
How to drop tablespace with missing datafile
Oracle error: no data found
The last transaction date every month
Collapsing a one-to-many result set
Is this where we use a RIGHT OUTER JOIN?
How to archive and decommission a database
What are the differences between database migration and database upgrades?
Taking export for all schemas
Exporting with LOBs
Importing tables with integrity constraints
Restoring a hot backup of a production database
File permissions when doing an RMAN backup
Converting Long Raw to Blob
Oracle certification tips and advice
Is Oracle 11i Applications or E-Business Suite a variation of Oracle Forms?
Installing Oracle 11g on Linux
Solving the ORA-1650 error message
Using the DRIVING_SITE hint
Running two instances of Oracle on one server
How to manually configure DB Control in Oracle
Using transparent gateways to access data in SQL Server
What is the difference between a relational database and a repository?
Can I write triggers from Oracle 7 to Oracle 11?
Running a Monday-Friday report to include weekend data
Return non-matching rows from both tables
Parsing in Oracle
Select from one table based on condition in another
I am running out of disk space, how do I hot swap my drives out?
Clone database vs. standby database
Taking a full offline backup
Using rule-based optimization to optimize a query
Cleaning a temporary tablespace