Solved

Load data from oracle table data to excel file

Posted on 2004-05-01
6
710 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
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

Online Training Solution

Drastically shorten your training time with WalkMe's advanced online training solution that Guides your trainees to action. Forget about retraining and skyrocket knowledge retention rates.

Question has a verified solution.

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

Working with Network Access Control Lists in Oracle 11g (part 1) Part 2: http://www.e-e.com/A_9074.html So, you upgraded to a shiny new 11g database and all of a sudden every program that used UTL_MAIL, UTL_SMTP, UTL_TCP, UTL_HTTP or any oth…
I remember the day when someone asked me to create a user for an application developement. The user should be able to create views and materialized views and, so, I used the following syntax: (CODE) This way, I guessed, I would ensure that use…
This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.
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.

732 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