Dave Costa questions

Dave Costa answers

• How to add cascade delete in oracle when the foreign key is on the same table
• SQLPLUS output to shell script not returning value
• Is there any reason to FK a PK column to itself
• How does the PL/SQL context work?
• 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?