Interested to Buy Any Domain ? << Click Here >> for more details...
What is the Lookup's and what is the use of lookup's?
- 3 Answers
- 37234 Views
- TCS, I also Faced
- E-Mail Answers
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 send me forms, xml pulisher questions,answers
What are the different components you should consider while defining a responsibility in oracle apps?
what are the balancing segments in AR?
How to create a purchase order without a requisition?
How can you achieve loose coupling in soa framework?
Explain oracle apps architecture.
what is global tempory table?
What is a value set? List its various types.
how do you describe O2C along with tables
Which oracle apps version you are very confident in?
If we have a repeated record in a table. But the repeated record how i can transfer from table to nested table?
q)what are the validations in sql*loader
What is oracle soa suite and what are its different components?
Tell me where we find the status of order information?
tell me the scenarios of the independent in reports
