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
5138 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

in oracle workflow if i want to send a mail to the user after sending if the user didn't approve the mail after 10 mins it is automatimatically approved how we can approach?

2 Answers Cap Gemini,

What is sca and how is it useful?

0 Answers

which parameters passed in report in oracle developer how to pass

3 Answers

What is the concept of soa governance?

0 Answers

How to attach the multiple templates in XML Pub Report?

2 Answers Intelligroup, KPIT,

how can we get odd numbered pages in output of a report

2 Answers Infosys,

what are the match approvals in PO?

3 Answers

in GL module specifing org_id or not?

1 Answers

Steps for DFF registration

2 Answers IBM, Savvis, Wipro,

what are the prerequisites for costing transactions?

0 Answers Scan Steel,

WHAT IS THE USE OF SKIP WHERE U WILL GIVE?

3 Answers

How to know the number of invoices generated for one PO from front end (navigation)?

1 Answers Oracle,

For more Oracle Apps Technical Interview Questions Click Here