what are external tables? how can we use external table instead of sql * loader to load data from flat file to staging table?
Answer Posted / priyanka
External table is like ctl file syntax but with in database script this will pick up the file from database then load data in to staging table.
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
testing tools?
Can u give the Documentation of Custom.pll in oracle apps
can we use look up type instead of a pofile option?or valueset?is it possible how?
How many schemas we have? how many you have used?
what is global tempory table?
Do you know what are user profiles in apps. Any examples you can give?
Tell me how to debug the report?
How is choreography different from orchestration?
List of all the modules under Manufacturing, Finance and Distribution in oracle applications?
How can you achieve loose coupling in soa framework?
is it possible to run the interface without using oracle apps?
how to print multi lay outs,muti currency,muti language in xml publisher
Tell me where we find the status of order information?
tell my any difficult situtation you solved in your experience in your company?
Can we create tables in apps schema?