Dave Costa questions

Dave Costa answers

• How to rotate table in Oracle?
• Getting this oracle error message: PLS-00330: invalid use of type name or subtype name
• Querying a Nested Table
• Cluster, Index and Partition on a single table
• Oracle range and subquery
• Is it better to join two fields together, or to compare them each to the same constant?
• Reading FOP images from database
• Use Oracle unnested VARRAY's instead of IN operator
• ORA-04045: errors during recompilation/revalidation
• Adding some logic to SQL query