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
What does appl_top directory contain?
List the types of flexfield?
what are the different transaction clauses in AR?
How can a process be deployed in soa?
Explain oracle apps architecture.
List the various types of value set.
tell me the scenarios of the independent in reports
How to create a purchase order without a requisition?
What do you understand by soa?
please send me forms, xml pulisher questions,answers
Are you familiar with internet architecture of oracle apps 11i?
how to print multi lay outs,muti currency,muti language in xml publisher
In sequence i want to 11 and 15th values how we will write?
what is the differences between internal requisition and internal sales order?
q)what are the validations in sql*loader