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

Explain how to schedule the report in b.o?

741


Explain about a task that really tested your analytical abilities?

996


What is the difference between user and versatile user?

755


Explain what are the steps to be taken to schedule the report?

824


Hi I'm using data federator.I would like to know if it allows select statment in where clause.For example: SELECT Employee, company, orgunit FROM TAB_BIG WHERE employee IN (Select TAB_SMALL.employee FROM TAB_SMALL WHERE flag = X ) bye

1626


Please send me BO certification details and question papers? this is my mail id: valsreenivas@gmail.com

2172


If I have three predefined prompts. In a report it will come randomly. How they will come in a specified format?

881


How we drill up week to month?

805


Can Bo generates the Report from the cubical data Explain?

1815


what is the difference b/w the refresh and buffered data?

1996


What is the difference between business requirement document and use case document.

772


Explain what is the difference between slice and dice and cross tab report?

804


Which versions are used in the bo dashboard work?

768


What if a cartesian product pop up block appears when running a report. Does it give wrong values? How to solve this issue?

794


Explain in detail about type 2(scd),

786