what are external tables? how can we use external table instead of sql * loader

what are external tables? how can we use external table instead of sql * loader to load data from flat file to staging table?

Question Posted / ch.sreenivaschary

1 Answers
5221 Views
IBM, I also Faced
E-Mail Answers

what are external tables? how can we use external table instead of sql * loader to load data from fl..

Answer / 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

More Oracle Apps Technical Interview Questions

What does appl_top directory contain?

0 Answers

where is setup of business group done?

2 Answers TCS,

is UOM maintained at master level or organization level or both?

3 Answers Scan Steel,

can we get profile values in report without using user exists is it possible how?

0 Answers Cap Gemini,

about TCA architecture

1 Answers TCS,

Hi, can anybody tell me where is the requirement of Oracle Apps (functional+technical) in industry,Iwant to join there,If possible than call me---9313174232

0 Answers

How to report output like below supplier name date amount abc software jan/11 10000 /* jan month total transactions*/ abc software feb/12 30000 /* feb month total transactions*/ dell computers jan/13 45000 /* jan month total transactions*/

4 Answers Satyam,

What are triggers?

3 Answers

HOW CAN U KNOW THE RESPONSIBILITY BELONGS TO OPERATING UNIT LEVEL OR NOT

2 Answers

when will formula,place holder and summary columns fire in reports?

1 Answers TCS,

In interface process we have 1000 records i want to commit every 100 records how? How i can commit every 100 records?

2 Answers

Please let me know the differance between Master Item and organization Item in Inventory.

5 Answers Wipro,

For more Oracle Apps Technical Interview Questions Click Here