AllExperts > Oracle 
Search      
Oracle
Volunteer
Answers to thousands of questions
 Home · More Oracle Questions · Answer Library  · Encyclopedia ·
More Oracle Answers
Question Library

Ask a question about Oracle
Volunteer
Experts of the Month
Expert Login

Awards

About Us
Tell friends
Link to Us
Disclaimer

 
 
 
 
About Suchitra Joshi
Expertise
I can answer questions regarding SQL, PL/SQL, Procedures, Functions, Triggers, SQL Loader, Oracle Forms, Oracle Reports, and some basic dba and performance tuning activities.

Experience
15+ years of Oracle PL/SQL Development

Education/Credentials
B.Sc (Electronics), Diploma in Computer Applications (DCA)

Awards and Honors
OCP - SQL and PL/SQL
Brainbench certifications in Oracle Administration, PL/SQL, Developer 2000

 
   

You are here:  Experts > Computing/Technology > Oracle > Oracle > file transfer

Oracle - file transfer


Expert: Suchitra Joshi - 4/14/2009

Question
How to convert oracle output text document into excel file.

If its possible please suggest me.

Thanks,
kamlesh.

Answer
Hi Kamlesh,

These are some ways to convert oracle output to excel file -

1) Using TOAD - select the rows from the table which are to be exported and save as excel or csv.
2) Using SQL*Plus - create a comma delimited file using the spool command and select statement as follows -

 spool emp
 select empno || ',' || ename || ',' || deptno from emp;
 spool off

 This will create emp.lst file. Open this using Excel.

Hope this helps.

Regards

Suchitra

Add to this Answer   Ask a Question


 
User Agreement | Privacy Policy | Kids' Privacy Policy | Help
Copyright  © 2008 About, Inc. AllExperts, AllExperts.com, and About.com are registered trademarks of About, Inc. All rights reserved.