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
- 10096 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
What is Tax Categories?
what are all the conversion and interfaces in GL,AP,AR,HRMS with example? otherwise send send link for these
What is supporting issues GL AP and AR?
difference of using cursor for loop and open,fetch,close.which one is better
What are the advantages of operating a database in ARCHIVELOG mode over operating it in NO ARCHIVELOG mode in Oracle?
as a technical developer in oracle applications which type errors feced in your experience sofar
What do you mean by hz_ in customer tables? : oracle accounts receivable
Can we modify approve purchase order?if yes what is navigation?
What are different types of receipt reversals ? Explain them : oracle accounts receivable
i want to know about the javaBean.what is its purpose and how it can use in Forms.
What is the disk migration? what is the steps involved in oracle disk migration?
What is the use of lockboxes? : oracle accounts receivable
What is the importance of batch source set up in ar? : oracle accounts receivable
TILL WHAT LEVEL OF SECURITY BO SUPPORTS?
Hi, I want to know basic information about Oracle HRMS and the institutes in hyderabad or the best faculty as i want to make my career in it.And also want to know may a person from non technical background be able to do this course. Regards, Swetha
