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

Explain in detail about type 2(scd),

1091


How to create a new calendar in CMC? Can u please tell me the process to create the required calendar. Ex:- Year of that calendar to start with Jan-15 and ends with Jan -30 and the Next month to start with Feb-31 and ends with Feb-14.

2441


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

1103


What is the difference between condition & filter?

1452


Let me know the things we can do in webi and cannot do it in full client and vice verse for bo6.5?

1099


How to create Index to the table in the universe designer and how it improves the Query performence

2543


When we use aggregate awareness function in designer?

963


Explain and tell me about a situation where your analysis of a problem was deemed to be incorrect? What would you have done differently?

1257


Explain how to schedule the report in b.o?

1045


can some body explain how migrate the BoXI r2 to BO 3.x and crystal reports XI r1 to Crystal report 2008 ?

1376


Migration of Reports from business objects 5.1.5 to samee version in different hardware?

2321


explain in detail about type 3?

1011


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

1007


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

1828


Tell me a business scenario where I can achieve the data through MINUS only not through subquery.

3071