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
- 4 Answers
- 9708 Views
- Oracle, Wipro, I also Faced
- E-Mail Answers
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
My requirement is like in database some defects are present and i need to clean them.To be brief for example every employee should have active assigments.So for those records which are not having status as active or null ,i need to update the roecords using API with the correct value. Client will provide a flat file for the records whch are defected.So i need to run the API for those records (flat file)and update the data in database. So my question is how to handle this requirement.Is there any existing API for this purpose?If yes then please send me the NAME. How to update the records in the database using flatfile. Any pointer will be appreciated.Thanks in advance.
Can we modify approve purchase order?if yes what is navigation?
What are the interface tables used for ar invoices, customers, receipts for conversion process? : oracle accounts receivable
PURCHASE ORDER TO PAYABLES WHAT ENTREIS WILL HAVE
A scenario for amount correction & how to use amount correction functionality in AP invoices
How to clone the database using RMAN back
What is the importance of batch source set up in ar? : oracle accounts receivable
now iam working as an hr executive in hyderabad i would like to learn oracle hrms kindly suggest me some good institutes in hyderabd
What is the difference between oracle media recovery and crash recovery?
How would you determine who has added a row to a table?
how can we add a field to the oracle standard forms through Form Persanlization or custom.pll
What Are Cross Validation & Adi?
we have 10 concurrent programs under one request group out of 10 ccps all users submitting only 9 programs from srs window remaining one ccp for specific user how can it possible send me answer asap.
Difference between negative and positive adjustments : oracle accounts receivable
what is the link between suppliers and banks in ap module in oracle apps? And also query?
