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
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.
What is auto invoicing? Explain : oracle accounts receivable
3. Steps in UAT?
how to write customizations in po
Explain about party and customer in ar : oracle accounts receivable
What are different types of receipt reversals ? Explain them : oracle accounts receivable
What is chargeback invoice? How do we create it? : oracle accounts receivable
PURCHASE ORDER TO PAYABLES WHAT ENTREIS WILL HAVE
Can you explain how to adjust the amount of advance already received against an invoice? : oracle accounts receivable
Explain accounting for invoice in advance and arrears. : oracle accounts receivable
How do you create a credit note against an invoice? : oracle accounts receivable
What are the standard concurent programs for auto invoice interface and customer interfaces? : oracle accounts receivable
1. What is PO rate variance gain and loss?
WHAT ALL DIFFERENT OPTIONS PRESENT IN WEBI?
How would you determine what sessions are connected and what resources they are waiting for?