| Spooling in SQLPlus 3.3 [message #36035] |
Wed, 31 October 2001 04:39  |
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;
----------------------------------------------------------------------
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
