Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

What is the Lookup's and what is the use of lookup's?

Answer Posted / kranthi kumar

Lookups are referred in more locations.
instead of storing the original value,we can store the
lookup codes.
this will reduce the space that is occupied in the database.
this is one reason.

the main reason is..

take an example...

in a table xx_emp there is one column gender.

possible values are
male m
female f
other o

define the above values in a lookup.

if u want to change the male to female ..u go and update
the lookups then automatically all the records referring to
that lookup will also change dynamically...

This saves time and complexity.

hope this clears the above question..........

Is This Answer Correct ?    42 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What does appl_top directory contain?

1078


List the types of flexfield?

989


what are the different transaction clauses in AR?

2054


How can a process be deployed in soa?

1159


Explain oracle apps architecture.

1191


List the various types of value set.

1019


tell me the scenarios of the independent in reports

2564


How to create a purchase order without a requisition?

1124


What do you understand by soa?

1099


please send me forms, xml pulisher questions,answers

2066


Are you familiar with internet architecture of oracle apps 11i?

1015


how to print multi lay outs,muti currency,muti language in xml publisher

12151


In sequence i want to 11 and 15th values how we will write?

2022


what is the differences between internal requisition and internal sales order?

2603


q)what are the validations in sql*loader

2331