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 do you understand by a set of books?
what are the balancing segments in AR?
What are the Standard Reports and Forms in HRMS?
Can u give the Documentation of Custom.pll in oracle apps
How to create a purchase order without a requisition?
A program must be written which accepts date parameter. The date parameter will accept data in the format DD/MM/YYYY. This data has to be validated and post validation, the following details have to be displayed for this date parameter 1. Input date must be defaulted to sysdate, It can be overridden by any other date. 2. Financial year should be displayed for this date parameter. Eg: If the input date is 30/11/2010, the financial year must be displayed as 1. From Date : 01-Aprr-2010 To Date: 31-Mar-2011 3. Calendar year and Calendar month must also be displayed. 4. The next payment cycle (say for EB), must be displayed based on this date parameter. 5. The previous payment must also be displayed based on this date.
please send me forms, xml pulisher questions,answers
What is oracle soa suite and what are its different components?
pls send me out bound code of supplers,site,bankiformation code pls as soon as
CAN YOU CUSTOMISE THE COUTOMISE CUS_TOP
List the types of flexfield?
where to define interorganization transaction charges and what are the different options?
how can i print random rows in plsql table
What do you understand by soa and what are the benefits of using this architecture?
what are the different transaction clauses in AR?