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
How can you achieve loose coupling in soa framework?
List the types of flexfield?
How many schemas we have? how many you have used?
What does appl_top directory contain?
what are the balancing segments in AR?
tell my any difficult situtation you solved in your experience in your company?
Suppose for report I have to parameters those are from_date and to_date, so to_date should be greater when compare to from_date, if we are giving to_date is lessthen it must shows some error how we will make?
What is count(*) from po_vendors(any table)?
What is oracle soa suite and what are its different components?
CAN YOU CUSTOMISE THE COUTOMISE CUS_TOP
What is a value set? List its various types.
testing tools?
In sequence i want to 11 and 15th values how we will write?
Hi Friends this is preetham, i am searching for job on oracle apps(technical) i put 3 years fake exp, so any one please could you help me for realtime interview questions and 9739782164 this is my no srpsrp777@gmail.Com please guys please provide your no for contact i have a doubts i want to clarify
How do you register report in oracle apps?