Q

Lookup table explained

What is the meaning of a lookup table, from an Oracle point of view?

What other point of view would there be? :)

Anyway, I'd call a lookup table any table that was created to hold mostly static data and is used to assist in normalizing your database design. For instance, if I create a state_lookup table that contains two columns: state_code and state_name. I now have the ability to store the state_code in any other table I want and retrieve the state_name from the "lookup" table as needed (via a join).

I don't think there's an "Oracle definition" of lookup table in particular. The concept of a lookup table is more a design/programming term than something that is a vendor specific term.

For More Information


Dig Deeper on Oracle database design and architecture

Start the conversation

Send me notifications when other members comment.

Please create a username to comment.

-ADS BY GOOGLE

SearchDataManagement

SearchBusinessAnalytics

SearchSAP

SearchSQLServer

TheServerSide.com

SearchDataCenter

SearchContentManagement

SearchHRSoftware

Close