ALLInterview.com :: Home Page KalAajKal.com
 Advertise your Business Here     
Browse  |   Placement Papers  |   Company  |   Code Snippets  |   Certifications  |   Visa Questions
Post Question  |   Post Answer  |   My Panel  |   Search  |   Articles  |   Topics  |   ERRORS new
   Refer this Site  Refer This Site to Your Friends  Site Map  Bookmark this Site  Set it as your HomePage   interview questions urls   External Links  Contact Us     Login  |  Sign Up                      
tip   SiteMap shows list of All Categories in this site.
Google
 
Categories  >>  Software  >>  Databases  >>  Oracle  >>  Oracle AllOther
 
 


 

 
 Oracle General interview questions  Oracle General Interview Questions
 OCI interview questions  OCI Interview Questions
 Architecture interview questions  Architecture Interview Questions
 Oracle Security interview questions  Oracle Security Interview Questions
 Database Management interview questions  Database Management Interview Questions
 Forms Reports interview questions  Forms Reports Interview Questions
 Oracle AllOther interview questions  Oracle AllOther Interview Questions
Question 
how can it possibble to see  the report output in excel 
sheet in oracle applications
 Question Submitted By :: Husenaiahb
I also faced this Question!!     Rank Answer Posted By  
 
  Re: how can it possibble to see the report output in excel sheet in oracle applications
Answer
# 1		 
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 ?    0 Yes 1 No
V.karthikeyan
 
  Re: how can it possibble to see the report output in excel sheet in oracle applications
Answer
# 2		 
through oracle discoverer.
 
Is This Answer Correct ?    0 Yes 0 No
Suman
 
 
 
  Re: how can it possibble to see the report output in excel sheet in oracle applications
Answer
# 3		 
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 ?    0 Yes 0 No
Esakkiraja
[HP]
 

 
 
 
Other Oracle AllOther Interview Questions
 
  Question Asked @ Answers
 
A Table has 10,000 records,How can i get latest 10 dates from the table.so that i can only store those 10 records in to my Resultset Object,to reduce load on my app? TCS4
WHAT IS CARTESIAN PRODUCT?  2
What command would you use to create a backup control file?  1
what are important reports in HRMS,GL,AP,AR in oracle apps? Pathway-Technologies1
i am having comm in emp table and i want to display 0 when comm =null and -10 if comm= value IBM4
What is the difference between the SQL*Loader and IMPORT utilities?  1
What is store procedure?and how do u take the values from database and run in scripts? Polaris1
Whats the purpose of using Nextval while creating the sequence. HCL2
HOW SHALL WE DIFFERENTIATE BETWEEN PRIMARY KEY AND FORIEGN KEY?  3
what is the difference between TRUNCATE and DELETE command in SQL TCS12
how to display last 5 letters from a name (take emp table ename ) IBM2
How can you gather statistics on a table?  2
When creating a user, what permissions must you grant to allow them to connect to the database?  1
How do you resize a data file?  1
Explain the difference between a hot backup and a cold backup and the benefits associated with each  1
What is index? How many types of indexes?  1
What is database schema?  2
Can We Restore a Table that accidantly dropped. TCS2
why r u using etl tool.  2
pl help me, i want oracle HRMS training institute address,in chennai  1
 
For more Oracle AllOther Interview Questions Click Here 
 
 
 
 
 
   
Copyright Policy  |  Terms of Service  |  Help  |  Site Map 1  |  Articles  |  Site Map  |   Site Map  |  Contact Us
   
Copyright © 2007  ALLInterview.com.  All Rights Reserved.

ALLInterview.com   ::  Forum9.com   ::  KalAajKal.com