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
Can you explain the difference between architecture followed in 10g & 11g?
Hi, Anybody please send me the Oracle APPS 1i technical interview questions (Real time) as wel as sample resume also?
List the types of flexfield?
In sequence i want to 11 and 15th values how we will write?
What do you understand by concurrent programs?
What is the concept of soa governance?
how can i print random rows in plsql table
Pls tel me the best text book for Oracle Apps 11i Tech? & I want D2K Text book also?
do you know is it possible to run the interface without using oracle apps?
Do you know where we can check the status of po?
what is pay run id ?
How many schemas we have? how many you have used?
What are do's and dont's of Interface?
how do you describe O2C along with tables
WHAT IS CUSTOM VIEW AND CUSTOM COMPONENT?