The Oracle Guru Answer #6

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

There are Comments. Add yours.

TIP: Want to include a code block in your comment? Use <pre> or <code> tags around the desired text. Ex: <code>insert code</code>

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
Sort by: OldestNewest

Forgot Password?

No problem! Submit your e-mail address below. We'll send you an email containing your password.

Your password has been sent to: