Home » SQL & PL/SQL » SQL & PL/SQL » sql output format
sql output format [message #644] Mon, 25 February 2002 12:44 Go to next message
Kane
Messages: 15
Registered: November 2001
Junior Member
Guys:

I want to generate a report from sql plus and the output should be in MS excel format.

spool c:/output.xls;
select * from emp;
spool off;

will give me an excel file. But the format is not delimited. Anyone has an idea on how to achieve this so when the user opens the file, it's properly seperated by the fields in excel?

Kane

Report message to a moderator

Re: sql output format [message #654 is a reply to message #644] Tue, 26 February 2002 01:44 Go to previous message
pratap kumar tripathy
Messages: 660
Registered: January 2002
Senior Member
try this

spool c:/output.xls;
select empno||','||ename||','||mgr from emp;
spool off;

Report message to a moderator

Previous Topic: trace the stored procedure
Next Topic: ORA-01839
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Apr 19 16:03:50 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.