My data source is Excel sheet. How to write the SQL
Statement for Excel file in data provider? Is is possible?

Answer Posted / obaidullah shareef

If we want to transfer the data from excel to Data base
table, you need to write one pl/sql code for that, this can
be easily done in Oracle Application with the help of
selecting the right table. This process is called inbound
interface in oracle apps and the file is called flat file.

Is This Answer Correct ?    1 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

what will be the contents for a functional requirements specifications

1777


please explain me with the real time tables on how aggregate tables are created and how aggregate awareness is addressed to it.

1533


Give some information on report bursting?

562


What task is 98% of the required work of a business analyst?

573


Explain the difference between union and group?

618






What is the difference in creating filters in designer and business objects?

580


How much data hold in one universe 336 can any one explain about core dimension, balanced dimension, and dirty dimension?

687


Explain how we drill up week to month?

635


What are the join problems comes appart from loop,chasm & fan Traps

1545


When we use aggregate awareness function in designer?

544


What is the profile and package?

1760


What is the dense rank?

667


Explain as a ba (business analyst) approaching a new piece of work, who would you interview and what questions would you ask?

547


can anybody tell me about complicated object you have created

2747


Can more than 1 metric be applied on an analytic in business objects?

1647