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

What is the profile and package?

2341


Explain when to use local filter and when to use global filter?

1401


If 2 tables are joined by Shortcut join, if query is generated based these join, what will be the join type and what will be the generated query? Thanks in advance?

2253


Can Bo generates the Report from the cubical data Explain?

2082


What are all the points to keep in consideration, while we are migrating the Universes,Reports from BO5.1.6 to BO 6.5? Is is compatible to migrate like this? Does it effect the filters in Reports and Join in the Universe?

2086


How can we do load testing for webi reports? (Example if I have have to test one webi report for concurrent users refreshing report at one time)?

1261


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

1090


Explain the difference between detect alias and detect context?

1136


Explain how we drill up week to month?

1138


What is aggregate table and aggregate fact table ... Any examples of both?

1104


Can we Save (save as) WEBI Doc as DESKI?

8290


In banking domain how many Fact tables,Dimension table are present?

8850


Give some information on report bursting?

1032


What sort of existing documents should business analysts refer to when starting on a new project?

1059


Difference between zabo and webi?

1150