Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

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

(1) Is it possible to create measures using objects from different context. (2) If cross context measures are not possible then what about @aggregate_aware() function ,here we use objects from different contexts. (3)Two measures from two different context ,can they be summed at report level.

1499


what is the difference between add link and include link in BO? Explain me with a scenario when to go for add link and when to go for include link?

10846


Explain how to execute the plsql procedure from the report by clicking with mouse?

1018


hi all of u, i want to learn the course in SAP(BI).because of there is no calls for BO. And the another region is it will be converted into SAP module. is it OK for me? is there any feauture in coming days? could any one plz send me the message

2036


Explain is there any default username & pwd for bo designer & supervisor?

987


What's the Functional & Architectural Differences between Business Objects & Web Intelligence Reports?

2128


What three things do you consider to be the most important factors for a manager?

1066


Explain the data types present in bo and what happens if we implement view in the designer and report?

998


Is there any tool that can compare two unvs / two rpts , built using bo 5.1 / bo 6.5?

964


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

1984


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

992


Regarding Hyperlinking in Business Objects. We have a few reports in QA environment where a number of hyperlinks are employed using OpenDoc function.In some of the reports,hyperlink is used to move to another tab within the same report.The formula used include "DocID" and ReportName="tab name".This works fine but now,for the PROD move,this will not work as the Doc Ids are subject to change. Is there a way to overcome this?Without DocID,how will move to a particular tab? Thanks in advance

5075


How to execute the plsql procedure from the report by clicking with mouse?

1114


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

1015


Can Bo generates the Report from the cubical data Explain?

2020