how can it possibble to see the report output in excel
sheet in oracle applications
Answers were Sorted based on User's Feedback
Answer / sumeet
How disgusting guys... the question is in oracle
applications not in toad or sql*plus. why you guys are
posting wrong and wrong answers.
the answer wud be select the report output format when you
submit the report concurrent thru SRS form window. There
you click on options and you will find output format.
Set it as desired "excel" and run the request.
Is This Answer Correct ? | 4 Yes | 0 No |
Answer / 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 |
Answer / esakkiraja
Very simple--If u have toad software first query the
statement and it will display all the values and there is
one option called save as use this option it will ask
which file format u want to save the values then give .xls
file and all the files will be saved in .xls format
Is This Answer Correct ? | 1 Yes | 4 No |
When the procedures or packagess become invalidate
A scenario for amount correction & how to use amount correction functionality in AP invoices
what is difference between inner join & nested query or subqueries
What is an Oracle database Full Backup?
CAN AUNIVERSE BE LINKED TO MORE THAN ONE DATASOURCE?
My requirement is like in database some defects are present and i need to clean them.To be brief for example every employee should have active assigments.So for those records which are not having status as active or null ,i need to update the roecords using API with the correct value. Client will provide a flat file for the records whch are defected.So i need to run the API for those records (flat file)and update the data in database. So my question is how to handle this requirement.Is there any existing API for this purpose?If yes then please send me the NAME. How to update the records in the database using flatfile. Any pointer will be appreciated.Thanks in advance.
8. Supporting AP, AR and GL?
what is the difference between TRUNCATE and DELETE command in SQL
23 Answers ICICI, Saama Tech, SkyTech, TCS,
How would you determine the time zone under which a database was operating?
Give the two types of tables involved in producing a star schema and the type of data they hold.
how can we add a field to the oracle standard forms through Form Persanlization or custom.pll
Explain the use of setting GLOBAL_NAMES equal to TRUE.