Home » SQL & PL/SQL » SQL & PL/SQL » Spooling in SQLPlus 3.3
Spooling in SQLPlus 3.3 [message #36035] Wed, 31 October 2001 04:39 Go to next message
Ivory Williams
Messages: 13
Registered: October 2001
Junior Member
-- When I run this script, it does not automatically - -- prompt user. "@c:/pay.sql" without anything but output showing
-- I am using SQLPlus 3.3
set heading off
set linesize 300
set feedback off
set echo off
set concat on
set termout off
spool c:/suntrustreport.csv
set concat off
select
TRANS||
ACCT_NO||
CHECK_SERIAL||
CHECK_AMT||
BANK_NO||
BATCH_NO||
lpad(REC_SUM,9,'0')||
ACTIVITY_DATE
from issue_tbl
where payno ='&payno'
order by TRANS;

----------------------------------------------------------------------
Re: Spooling in SQLPlus 3.3 [message #36037 is a reply to message #36035] Wed, 31 October 2001 06:48 Go to previous message
Suresh Vemulapalli
Messages: 624
Registered: August 2000
Senior Member
remove set termout off from your script file and try

----------------------------------------------------------------------
Previous Topic: Please advice on my first PL-SQL code
Next Topic: Unloading a BLOBs
Goto Forum:
  


Current Time: Mon Oct 26 14:37:45 CDT 2020