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 ALL DIFFERENT KIND OF FUNCTIONS AVAILABLE WHILE DESIGN UNIVERSES?
Explain about party and customer in ar : oracle accounts receivable
Which is the best institute in Hyderabad to learn OBIEE and DataStage?Please tell me faculty name also
Can you explain how to adjust the amount of advance already received against an invoice? : oracle accounts receivable
What are the advantages of operating a database in ARCHIVELOG mode over operating it in NO ARCHIVELOG mode in Oracle?
while creating requisitions i am unable to see the list of organisation can anyone help me out ?
How to clone the database using RMAN back
I need a Technical evaluation between Oracle and SAP ? please do a need ful.
How to move the data from one flatfile to multiple staging tables?give me some examples? for example in po interface one flat file is there and multiple staging tables are there how can move it?please give me answer for this question?
3. Steps in UAT?
how can we add a field to the oracle standard forms through Form Persanlization or custom.pll
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
What view would you use to determine free space in a tablespace?
what is the link between suppliers and banks in ap module in oracle apps? And also query?
WHAT ALL DIFFERENT OPTIONS PRESENT IN WEBI?