Lookup Table in Oracle Database | Use of Lookup Table in Oracle Database | What is Lookup Table in Oracle Database ?
-
Lookup Table are like constraints which hold a value. The Content in the Lookup tables doesn't change often, hence referred as lookup.
-
Where Can We use these type of table ? For Example in Countries Table - Countries are not added on regular bases hence one can consider the table as a lookup table. As ad when needed in some other table the countries information can be fetched base on PK - Country-Code column. Eg - Emp_Per_Info.