how can it possibble to see the report output in excel
sheet in oracle applications

Answers were Sorted based on User's Feedback



how can it possibble to see the report output in excel sheet in oracle applications..

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

how can it possibble to see the report output in excel sheet in oracle applications..

Answer / suman

through oracle discoverer.

Is This Answer Correct ?    1 Yes 2 No

how can it possibble to see the report output in excel sheet in oracle applications..

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

how can it possibble to see the report output in excel sheet in oracle applications..

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

Post New Answer

More Oracle AllOther Interview Questions

When the procedures or packagess become invalidate

3 Answers   TCS,


A scenario for amount correction & how to use amount correction functionality in AP invoices

0 Answers  


what is difference between inner join & nested query or subqueries

0 Answers  


What is an Oracle database Full Backup?

0 Answers  


CAN AUNIVERSE BE LINKED TO MORE THAN ONE DATASOURCE?

0 Answers  


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.

0 Answers   Wipro,


8. Supporting AP, AR and GL?

0 Answers   Oracle,


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?

1 Answers  


Give the two types of tables involved in producing a star schema and the type of data they hold.

1 Answers  


how can we add a field to the oracle standard forms through Form Persanlization or custom.pll

0 Answers   TCS,


Explain the use of setting GLOBAL_NAMES equal to TRUE.

1 Answers  


Categories
  • Oracle General Interview Questions Oracle General (1808)
  • Oracle DBA (Database Administration) Interview Questions Oracle DBA (Database Administration) (261)
  • Oracle Call Interface (OCI) Interview Questions Oracle Call Interface (OCI) (10)
  • Oracle Architecture Interview Questions Oracle Architecture (90)
  • Oracle Security Interview Questions Oracle Security (38)
  • Oracle Forms Reports Interview Questions Oracle Forms Reports (510)
  • Oracle Data Integrator (ODI) Interview Questions Oracle Data Integrator (ODI) (120)
  • Oracle ETL Interview Questions Oracle ETL (15)
  • Oracle RAC Interview Questions Oracle RAC (93)
  • Oracle D2K Interview Questions Oracle D2K (72)
  • Oracle AllOther Interview Questions Oracle AllOther (241)