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
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 |
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 |
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 |
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 |
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 |
What is the maximum number of statements that can be specified in a trigger statement?
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*/
Tell me how to debug the report?
explain registration steps of a concurrent program.
List some exceptions other than NO_DATA_FOUND, TOO_MANY_ROWS and WHEN OTHERS
Is that Possible To create package Overloading , If Yes Give any Examples
Where we can write a PL/SQL code in report triggers?
how to create requst set in oracle apps and how to send muliple requests at a time,
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.
what are the pl/sql tables
what is item status? name the related table.
WHAT IS REFCURSOR IN ORACLE ?