Re: Sql output .Urgent help needed folks

From: Ganesh Raja <ganesh_at_gtfs-gulf.com>
Date: 19 Dec 2001 05:31:23 -0800
Message-ID: <a8aed4.0112190531.6af3d742@posting.google.com>

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?

No trick here....

Sqlplus -s Scott/tiger << !EOF
Set Heading off
set feedback off
set pagesize 1000
set linesize 1000
Spool My.LST
Select * from Emp;
Spool Off
Exit
!EOF There that does the Trick

HTH
>
> SET SPOOL On will spool the SQL also, i dont want that to happen
>
> Any help appreciated folks.

Regards,
Ganesh R Received on Wed Dec 19 2001 - 07:31:23 CST