Ask the Experts

Ask the Experts

• Using SQL Automatic Workload Repository to find Active Session History

  SQL expert Karen Morton explains how to use the Automatic Workload Repository (AWR) in SQL to find the Active Session History (ASH) of a session.  Continue Reading

• How to change the date format in SQL with the style parameter

  Find out how to change the date format using the style parameter in the CONVERT call in this tip from SearchOracle.com SQL expert Karen Morton.  Continue Reading

• How to license a two-node, Oracle mirrored environment

  Do you need to license both nodes in an Oracle mirrored environment? Learn the answer in this tip from Oracle licensing expert Scott Rosenberg.  Continue Reading

• How fingerprint scanning works with Oracle 9i security

  Interested in using fingerprint scanning in Oracle 9i? Learn about Oracle 9i security and how it works with a biometric scanner in this tip from Oracle security expert Brian Fedorko.  Continue Reading

• Using the Oracle CEIL function to round to nearest five thousandth

  The Oracle CEIL function can be used to round to the nearest five thousandth. Learn how to do this in this tip from SQL expert Karen Morton.  Continue Reading

• How to use a CASE statement in SQL to change gender values in a column

  Learn how to use a CASE statement in SQL to convert all values in a column from female to male or male t female in this tip from SQL expert Karen Morton.  Continue Reading

• Understanding Oracle/VMware licensing policies

  Learn about the Oracle/VMware licensing policy and why Oracle is treating VMware as soft partitioning in this tip from Oracle licensing expert Scott Rosenberg.  Continue Reading

• What is the required skill set for an Oracle RAC DBA?

  Interested in becoming an Oracle RAC DBA? Learn about the necessary skill set and what kind of knowledge is necessary to work with Oracle RAC in this tip from an Oracle ACE director.  Continue Reading

• How to use the SQL MAX function to sum the values of a column

  SQL expert Karen Morton explains how to use the SQL MAX function to sum the values of one column based on comparison with another in this expert tip.  Continue Reading

• How to use GROUP BY GROUPING SETS to find books with multiple authors

  SQL expert Karen Morton explains how to use GROUP BY GROUPING SETS in an SQL query to find all books with more than one author in your books database.  Continue Reading

• Understanding foreign key column naming conventions

  Want to know how to name the foreign key column in your table? This tip from Oracle PL/SQL expert Dan Clamage will help you understand the best way to name a foreign key column.  Continue Reading

• Why doesn’t Oracle documentation contain more detail on licensing?

  Not finding Oracle documentation on licensing helpful? Expert Scott Rosenberg explains why Oracle licensing documentation may not give as much detail on licensing rules and guidance as you may like.  Continue Reading

• Using the PL/SQL input parameter and forward slash in a PL/SQL program

  Learn how to use the PL/SQL input parameter and forward slash in a PL/SQL program to avoid an error message in this tip from PL/SQL expert Dan Clamage.  Continue Reading

• Do I need to pay extra for licenses for an Oracle Partitioning Option?

  Do you have an Oracle Partitioning Option installed in your database? Learn whether you need to pay extra for licensing and how to be compliant in this tip from an Oracle licensing expert.  Continue Reading

• 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