The Oracle Guru Were you correct? This week's answer is:
a. graphically represent database design

When trying to show inheritance in a table with a parent-child relationship, SearchOracle.com guru Frank Kulash says three main steps are needed:

  • Normalizing the data

  • Bottom-Up hierarchical query

  • Finding the root in hierarchical queries

Click to read Frank's detailed explanations of each step.

Click for the definition of inheritance.

For More Information

Chapter excerpt: PL/SQL: What, when, and where

Best Web Links: Languages and Development

Do you have an idea for a quiz question topic? Let us know!


This was first published in August 2003