Ask the Experts

Ask the Experts

• What are the best PL/SQL books?

  Read Oracle expert Dan Clamage’s recommendations for PL/SQL books that allow readers to gain a basic understanding of PL/SQL, along with other places to find PL/SQL resources.  Continue Reading

• Can I run Oracle 9i on a Windows 64-bit O/S?

  If you want to migrate Oracle 9i to a Windows 64-bit O/S environment, learn in this expert tip why you may want to install Oracle 10g or 11g first.  Continue Reading

• How to run an Oracle database backup script during off hours

  Want to run an Oracle database backup script during off hours? Learn how with these samples scripts from an Oracle expert.  Continue Reading

• How can I find similar values in two Oracle tables in PL/SQL?

  Looking to find similar values in two Oracle tables in PL/SQL? Learn about how to do so with this tip from Oracle PL/SQL expert Dan Clamage.  Continue Reading

• How to use Log Miner to verify filtered Oracle NULL columns

  Learn how to use Log Miner to verify filtered Oracle NULL columns in an INSERT statement from a redo log write in this tip from Oracle database expert Brian Peasland.  Continue Reading

• How to use the CREATE USER command to create a new username in Oracle

  Oracle expert Brian Peasland explains how to use the CREATE USER command to create a new username and password for your Oracle database.  Continue Reading

• When to use double quotes in Oracle column to avoid invalid identifier

  Are you seeing an invalid identifier? Learn when to use double quotes in Oracle column names to avoid this in this tip from PL/SQL expert Dan Clamage.  Continue Reading

• How to avoid duplicates of Oracle delimited codes in CLOB column

  Learn how to avoid duplicates of Oracle delimited codes in a CLOB column by scanning the column in this tip from Oracle PL/SQL expert Dan Clamage.  Continue Reading

• Can I copy table data with unlike primary keys from Table1 to Table2?

  Oracle PL/SQL expert Dan Clamage explains two methods for copying table data from table1 to table2 when the tables have different primary keys in this expert tip.  Continue Reading

• How to use iterative scans to create hierarchical queries in SQL

  PL/SQL expert Dan Clamage explains how to use iterative scans to create hierarchical queries in SQL that are database agnostic.  Continue Reading

• How to list rows with special characters in PL/SQL

  Want to learn how to list rows with special characters in PL/SQL? Read this tip from our PL/SQL expert for advice on how to write a PL/SQL query using the translate, char or trunk functions.  Continue Reading

• How to use a stored procedure to fetch from ref cursor in Oracle

  Oracle expert Dan Clamage explains how to use a stored procedure to fetch from a ref cursor in Oracle in this tip.  Continue Reading

• Why can't I install Oracle 9i on Windows 2003?

  Having trouble installing Oracle 9i on Windows 2003? Learn why in this tip from Oracle expert Brian Peasland.  Continue Reading

• How to perform database recovery with a corrupt control file in Oracle

  Learn how to perform database recovery with a corrupt control file in Oracle with these step by step instructions, including how to use the CREATE CONTROLFILE command, from Oracle expert Brian Peasland.  Continue Reading

• How to perform a Big to Little Endian conversion in Oracle 8i

  Learn how to perform a Big to Little Endian conversion in Oracle 8i using either an Oracle upgrade or export/import in this tip from Oracle expert Brian Peasland.  Continue Reading