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
what are basic modules required to implement oracle application in any oraganisation?
where the dff data will be stored
how to write customizations in po
I need a Technical evaluation between Oracle and SAP ? please do a need ful.
What is autocashrule set? : oracle accounts receivable
What are different types of receipt reversals ? Explain them : oracle accounts receivable
WHAT ALL DIFFERENT OPTIONS PRESENT IN WEBI?
3. Steps in UAT?
what ASIS BUSINESS PROCESS IN ORACLE FINANCE
PURCHASE ORDER TO PAYABLES WHAT ENTREIS WILL HAVE
Explain the process of recievables in oracle financials. : oracle accounts receivable
How I can load an image into image item on Forms. I want to know about built-ins and procedure. and also code for it.
HOW TO SPOT AHIERARCHY?
Differentiate between standard remittance and bills receivable remittance : oracle accounts receivable
as a technical developer in oracle applications which type errors feced in your experience sofar