Are there any alternate tools other than sql* loader to
load data into oracle apps tables from external systems

Answers were Sorted based on User's Feedback



Are there any alternate tools other than sql* loader to load data into oracle apps tables from ext..

Answer / raam

Apart from sql*loader you can use UTL_FILE package to
upload the data from external systems to oracle tables.

Is This Answer Correct ?    21 Yes 3 No

Are there any alternate tools other than sql* loader to load data into oracle apps tables from ext..

Answer / amit trivedi

If you are on 9i and above you may use External Tables as
well. Though this feature has some limitations as to type
of delimiters that can be used.

Is This Answer Correct ?    7 Yes 1 No

Are there any alternate tools other than sql* loader to load data into oracle apps tables from ext..

Answer / viswa

data loder,
utl_file,
with dba link(data should be in table),
pro*c,
style sheet convertion,
ora loader(tool)

Is This Answer Correct ?    6 Yes 0 No

Are there any alternate tools other than sql* loader to load data into oracle apps tables from ext..

Answer / sachind

Apart from SQL Loader, web-adi can be used.Data Load is
another one but its windows specific.

Is This Answer Correct ?    3 Yes 2 No

Are there any alternate tools other than sql* loader to load data into oracle apps tables from ext..

Answer / kks

You can use data pump (IMPDP) connect to external DB via DB
link and load the data.

Is This Answer Correct ?    1 Yes 0 No

Post New Answer

More Oracle Apps Technical Interview Questions

In support project one ticket alloted which steps follows manualy tell me ?

0 Answers   BEL, Questam,


Matrix Report: Simple, Group above, Nested

1 Answers  


why do we go for oracle apps technical other than sap and other packages?

2 Answers  


What is Value Set?

2 Answers   Accenture,


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

0 Answers   Cap Gemini,






difference b/w procedures&functions

2 Answers   Oracle, TCS,


List the types of flexfield?

0 Answers  


What is the interface?

3 Answers  


Assume i have three Procedures defined in a Package Spec. I have created the Package Specification. now i create the Package Body by including the three procedures in addition to that i include a fourth procedure which is not included in my Package Spec. I compile the Package Body. Will the Package body Compile ? What will the end result ? what will happen if the execute the package by calling the 4th procedure ?

7 Answers   Satyam,


what do u mean by debit/credit memo invoices?

3 Answers   ACC, Convergys, Mascon,


What are Mandatory triggers to write in the block, which is created on view?

5 Answers   Oracle,


We have to show a logo/image in a report? what are the steps and which format it is?whether in pdf format is applicable or not?

3 Answers   IBM,


Categories
  • Oracle Apps Technical Interview Questions Oracle Apps Technical (547)
  • Oracle Apps Financial Interview Questions Oracle Apps Financial (793)
  • Oracle Apps Manufacturing Interview Questions Oracle Apps Manufacturing (53)
  • Oracle Apps HRMS Interview Questions Oracle Apps HRMS (169)
  • Oracle Apps CRM Interview Questions Oracle Apps CRM (9)
  • Oracle Apps SCM Interview Questions Oracle Apps SCM (141)
  • Oracle Install Base Interview Questions Oracle Install Base (62)
  • Oracle Service Contracts Interview Questions Oracle Service Contracts (101)
  • Oracle Apps AllOther Interview Questions Oracle Apps AllOther (114)