Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

  1. Categories >> Software >> Databases >> Oracle >> Oracle AllOther
  2. Suggest New Category

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

Question Posted / v.karthikeyan

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


Please Help Members By Posting Answers For Below Questions

I need a Technical evaluation between Oracle and SAP ? please do a need ful.

1995

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

2399

What is db_recovery_file_dest in oracle? When do you need to set this value?

1125

what are the API of GL,PO,AP

2269

What do you mean by hz_ in customer tables? : oracle accounts receivable

1221

What is the meaning of "Modulus" and "Alignment" in a datafile. Data file might be from any database. Data file is created through unloading data from a table. So, while loading this data into my table, I need to use these keywords. Could any one can help me regarding this?

2186

Differentiate between writeoff and receipt writeoff. : oracle accounts receivable

1346

1.In a table Gender is a column in that male and female are the two data.In a single statement i have to modify all male to female and all female to male vice versa. 2.In a single query i need the count of male data,count of female and total count

17641

Hi, I want to know basic information about Oracle HRMS and the institutes in hyderabad or the best faculty as i want to make my career in it.And also want to know may a person from non technical background be able to do this course. Regards, Swetha

2525

Explain how to account for bank charges deducted from amount received against an invoice. : oracle accounts receivable

1295

What is Tax Categories?

2112

How would you determine who has added a row to a table?

2316

What is auto invoicing? : oracle accounts receivable

1159

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

2280

how to replace not in with not exist?

3739