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

What is the maximum number of statements that can be specified in a trigger statement?

1 Answers   Oracle,


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,


Tell me how to debug the report?

0 Answers  


explain registration steps of a concurrent program.

1 Answers   TCS,


List some exceptions other than NO_DATA_FOUND, TOO_MANY_ROWS and WHEN OTHERS

3 Answers   Satyam,


Is that Possible To create package Overloading , If Yes Give any Examples

1 Answers   PWC,


Where we can write a PL/SQL code in report triggers?

2 Answers   IBM,


how to create requst set in oracle apps and how to send muliple requests at a time,

1 Answers   Genpact,


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.

0 Answers   Accenture,


what are the pl/sql tables

1 Answers   IBM,


what is item status? name the related table.

1 Answers   Scan Steel,


WHAT IS REFCURSOR IN ORACLE ?

6 Answers  


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)