The Oracle Guru Answer #6

Check to see if you answered this week's quiz correctly.

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 last published in August 2003

Dig Deeper on Oracle DBA jobs, training and certification

PRO+

Content

Find more PRO+ content and other member only offers, here.

Start the conversation

Send me notifications when other members comment.

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

Please create a username to comment.

-ADS BY GOOGLE

SearchDataManagement

SearchBusinessAnalytics

SearchSAP

SearchSQLServer

TheServerSide

SearchDataCenter

SearchContentManagement

SearchFinancialApplications

Close