Solved

Load data from oracle table data to excel file

Posted on 2004-05-01
6
706 Views
Last Modified: 2012-08-14
Dear All,

How do I load data from oracle table to excel file?
I preffered process that can be called directly from oracle procedure.

Regards,
Maulin
0
Comment
Question by:maul_shah
6 Comments
 
LVL 5

Accepted Solution

by:
fmonroy earned 43 total points
ID: 10966894
mmm... not from a procedure but a easy way is to do a "," separated values using the log feature from sqlplus. CSV files can be read by excel
0
 
LVL 3

Assisted Solution

by:dbms_chu
dbms_chu earned 41 total points
ID: 10967487
Take a look at this posting on Asktom.
http://asktom.oracle.com/pls/ask/f?p=4950:8:16395213932600298379::NO::F4950_P8_DISPLAYID,F4950_P8_CRITERIA:769425837805,

It has a procedure to create an excel file.
0
 
LVL 8

Assisted Solution

by:annamalai77
annamalai77 earned 41 total points
ID: 10974606
hi there

before following how to save data in excel.
spool the data into a file and then follow the steps

spool d:\a.txt
select * from table;
spool off

kindly follow the steps given below to open the output file in excel

1. open excel
2. then open the output file generated by oracle.
3. in the text import wizard window, select fixed width radio button option from original data type frame.
4. then click next button
5. in the second window after clicking the next button from the first screen, just click on the ruler wherever u want to have a separator. wherever u dont want to have a separator, just double click on it. continue till all the columns have a proper separator in place.
5. then click the next button.
6. in the third screen, for every column select the datatype. by default all the columns will be in general format. its always better to select text option wherever ur sure its a text column, because leading zeros will be trucated when u leave the text columns in general option.
7. once all the columns have be assigned proper datatype, click finish.

wallah, there ur , ur output file in excel.

regards
annamalai
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Oracle Finace 3 67
one-way data "masking" MD5 sql 26 146
Bash Script to Analyze Oracle Schemas 11 84
oracle 11g 23 50
This article started out as an Experts-Exchange question, which then grew into a quick tip to go along with an IOUG presentation for the Collaborate confernce and then later grew again into a full blown article with expanded functionality and legacy…
Configuring and using Oracle Database Gateway for ODBC Introduction First, a brief summary of what a Database Gateway is.  A Gateway is a set of driver agents and configurations that allow an Oracle database to communicate with other platforms…
This video shows how to Export data from an Oracle database using the Datapump Export Utility.  The corresponding Datapump Import utility is also discussed and demonstrated.
This video explains what a user managed backup is and shows how to take one, providing a couple of simple example scripts.

895 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

12 Experts available now in Live!

Get 1:1 Help Now