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

Dig deeper on Oracle DBA jobs, training and certification

Pro+

Features

Enjoy the benefits of Pro+ membership, learn more and join.

0 comments

Oldest 

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:

SearchDataManagement

SearchBusinessAnalytics

SearchSAP

SearchSQLServer

TheServerSide

SearchDataCenter

SearchContentManagement

SearchFinancialApplications

Close