how can it possibble to see the report output in excel
sheet in oracle applications
- 4 Answers
- 9016 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 the use of lockboxes? Steps for lock box : oracle accounts receivable
What is auto accounting what are the steps for setting up auto accounting? : 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.
Why more redos are generated when the oracle database is in begin backup mode?
WHAT ARE TEMPLATES?EXPLAIN WHAT YOU HAVE CREATED?
i am working with OC 4.5 i have numbers in table in 10 row with some null values please tell me how to find total? Thanks
What is the difference between conversions and interfaces? : oracle accounts receivable
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
Differentiate between writeoff and receipt writeoff. : oracle accounts receivable
what are the tools used for oracle 10g in real time.
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 is the link between suppliers and banks in ap module in oracle apps? And also query?
IS IT POSSIBLE TO CREATE REPORTS FROM DIFFERENT UNIVERSES IN ONE DOCUMENT?
Explain prerequisites and post activities of oracle database installation
What is the Difference between the Person_Type_id column in the per_all_people_f and per_person_type_usages_f
