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
where the dff data will be stored
CAN AUNIVERSE BE LINKED TO MORE THAN ONE DATASOURCE?
I've got a database 10g and Form version 5.0 but unable to connect. Does Oracle 10g database supports form 4.5
PURCHASE ORDER TO PAYABLES WHAT ENTREIS WILL HAVE
1)After defining value set we define list of values, I need to enter 1000 values with out entering manually, how will you do that? 2)what are the parameters we use in a concurrent program? 3)what is payroll processing? 4)In organization window after defining an organization and organization classification how to create a new item in the others button? 5)If there are 10 users, How to restrict the selected users not to access the forms?
What do you mean by hz_ in customer tables? : oracle accounts receivable
What is db_recovery_file_dest in oracle? When do you need to set this value?
default triggers available for reports
can u give guidance abt packages of plsql
what are the tools used for oracle 10g in real time.
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 is auto invoicing? Explain : oracle accounts receivable
as a technical developer in oracle applications which type errors feced in your experience sofar
Is there any link between pr form(purchse requisition)and po form(purchase order)
What is an Oracle database Full Backup?