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...

how can it possibble to see the report output in excel
sheet in oracle applications

Answer Posted / v.karthikeyan

I suppose you would be retrieving data using SQL. You can
spool the data. Spooled data can be viewed in excel. The
teps involved are as follows:-

In SQL prompt, enter spool filename.txt
Enter the select statement you want to issue
execute it
After the qry returned the rows, enter spool off.

This file can be opened by EXCel through import menu

Is This Answer Correct ?    2 Yes 4 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

where the dff data will be stored

2428


CAN AUNIVERSE BE LINKED TO MORE THAN ONE DATASOURCE?

2065


I've got a database 10g and Form version 5.0 but unable to connect. Does Oracle 10g database supports form 4.5

2512


PURCHASE ORDER TO PAYABLES WHAT ENTREIS WILL HAVE

2210


1)After defining value set we define list of values, I need to enter 1000 values with out entering manually, how will you do that? 2)what are the parameters we use in a concurrent program? 3)what is payroll processing? 4)In organization window after defining an organization and organization classification how to create a new item in the others button? 5)If there are 10 users, How to restrict the selected users not to access the forms?

2180


What do you mean by hz_ in customer tables? : oracle accounts receivable

1206


What is db_recovery_file_dest in oracle? When do you need to set this value?

1123


default triggers available for reports

2204


can u give guidance abt packages of plsql

2162


what are the tools used for oracle 10g in real time.

2435


I am Bsc Computer Science Graduate, I have good knowledge in SQL 7.0, Can I go for Oracle APPS course please suggest me the answer

2257


What is auto invoicing? Explain : oracle accounts receivable

1122


as a technical developer in oracle applications which type errors feced in your experience sofar

2314


Is there any link between pr form(purchse requisition)and po form(purchase order)

2712


What is an Oracle database Full Backup?

1125