-
ORA-19566 error with RMAN backup in Oracle 8i
ORA-19566 error with RMAN backup in Oracle 8i
-
How to return multiple values for THEN clause in an SQL CASE expression
Read this tip from SQL expert Rudy Limeback on how to return multiple values in THEN clause of SQL CASE expression.
-
Using LEFT OUTER JOIN query to get zero row counts in SQL
An SQL expert explains how using a LEFT OUTER JOIN query can retrieve zero row counts in SQL.
-
Can I concatenate row values in SQL?
An Oracle user asks SQL expert Rudy Limeback if there is an SQL query that will concatenate two different tables with different numbers of rows.
-
Should I try to avoid a LEFT OUTER JOIN in SQL?
An Oracle user asks expert Rudy Limeback whether avoiding a LEFT OUTER JOIN in SQL is a good SQL strategy.
-
How to write an SQL query for two foreign keys to the same table
A SQL user asks how to write a query for two foreign keys to the same table. Read SQL expert Rudy Limeback's answer here.
-
How to create an SQL CHECK constraint for two letters
SQL expert Rudy Limeback explains how to create a SQL CHECK constraint for two letters when trying to write a query to retrieve data from two tables.
-
Tips for derived tables in SQL and using FULL OUTER JOINs
SQL expert Rudy Limeback gives his strategy for using FULL OUTER JOINs on derived tables in SQL. Read the tip here.
-
How to delete a partition on the F: drive with Oracle on Windows
Get tips on how to delete and recreate a partition on the F: drive in which Oracle is installed.
-
How to disable Oracle constraints and triggers during an import in 10g
An Oracle user asks expert Brian Peasland if constraints and triggers can be disabled on an Oracle import in Oracle 10g and how to complete this task.
-
Should we worry about Oracle memory leaks on Windows?
Oracle expert Brian Peasland explains how to evaluate if Oracle memory leaks will be an issue on a Windows platform and how to use Real Application Clusters (RAC) for scaling up and out.
-
What is a staging table, and how is the staging concept used in Oracle?
Expert Brian Peasland gives an example of what the staging concept is and how to use a staging table in Oracle.
-
What could be causing an SQL count 0 with a successful Oracle import?
Get tips for fixing the problem of getting an SQL count 0 with a successful Oracle import.
-
Is a hot backup part of a backup database using RMAN?
How can the System Change Number (SCN) be used to perform a hot backup for a backup database using RMAN? Learn the answer here.
-
How to configure Oracle DB_BLOCK_SIZE and Solaris operating system block size
Read this expert explanation of DB_BLOCK_SIZE vs. operating system block size configuration in an Oracle 10g database operating on Solaris 10.
-
How does Oracle instance recovery work and what happens internally?
Oracle expert Brian Peasland explains how an Oracle instance recovery works and what happens internally during the process in this tip.
-
Tips for using parameters in an Oracle dump file import
Oracle expert Brian Peasland explains the function of certain parameters when importing an Oracle dump file from one Oracle server to another.
-
How to back up Oracle 10g RAC database on an AIX system
An Oracle user wants to take a backup of an Oracle 10g RAC database on an AIX system. Read an expert's advice here.
-
How to write an SQL query using GROUP BY for row analysis
SQL expert Rudy Limeback explains how to write a SQL query using GROUP BY to retrieve the students who have all three rows in a skills table.
-
How to return a zero in SQL instead of no row back for a select count
Want your row to return a zero instead of getting no row backs for some combinations when doing a select count in SQL? Find out how here.
-
Perfect the Oracle RMAN duplicate 10g command
One reader asks expert Brian Peasland a question about datafile sizes with the Oracle RMAN duplicate 10g command.
-
Do SQL arithmetic without using arithmetic operations
Learn how to do simple SQL arithmetic operations without using the arithmetic operators.
-
Managing SQL parent table-child table relations
Managing parent table-child table relations in Oracle SQL environments is key to efficient programming.
Submit a question to our experts