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 TEMPLATES?EXPLAIN WHAT YOU HAVE CREATED?
Explain the use of table functions.
HOW TO SAVE UNIVERSES AND DOCUMENTS IN THE REPOSITORY?
if i write the procedure.. and other person make the changes in that code then where i find who is changing my procedure
What are different types of receipt reversals ? Explain them : oracle accounts receivable
What do you mean by hz_ in customer tables? : oracle accounts receivable
Give two methods you could use to determine what DDL changes have been made.
how to write customizations in po
what are all the conversion and interfaces in GL,AP,AR,HRMS with example? otherwise send send link for these
how can we add a field to the oracle standard forms through Form Persanlization or custom.pll
as a technical developer in oracle applications which type errors feced in your experience sofar
Explain accounting for invoice in advance and arrears. : oracle accounts receivable
What is the use of lockboxes? : oracle accounts receivable
what are basic modules required to implement oracle application in any oraganisation?
What is the importance of batch source set up in ar? : oracle accounts receivable