Re: Sql output .Urgent help needed folks

mark_brehmen_at_yahoo.com (mark) wrote in message news:<fa4781e4.0112182358.4c5b9ea3_at_posting.google.com>...
> I have a Sql , say select * from emp
>
> I want to spool only the output to an Sql File. How
> should i do it?. Is there some trick?
>
> SET SPOOL On will spool the SQL also, i dont want that to happen
>
> Any help appreciated folks.

You want to just

spool yourfilename

select * from emp;

spool off

This will create a file named yourfilename.lst with a few extra characters that you probably don't want. For something a little cleaner, you can do things like:

set feed off
set verify off
set echo off

To see all the settings, say show all. To find out what it all means, see the SQL*Plus Users Guide and Reference. You can get it from http://otn.oracle.com in pdf format, probably have to register. See also the various link pages people have, and http://www.orafaq.com , http://www.revealnet.com etc.

jg

--
http://www.garry.to
I remember when it wasn't entirely clear that SQL was going to be
the...data interchange language?