-
Getting duplicate results in sql plus
I am calling a sqlplus script from within perl and everytime I run it I get duplicate results in the output for instance
I get
trade datet numb
______________
1 38 22
trade datet numb
______________
1 38 22
Here is my sql script
SET TERMOUT OFF
SPOOL PENDING_TRADES.TXT
SET serveroutput ON
COLUMN Count FORMAT A15
select TO_CHAR(count(*)) as Count
from Trade
;
SET LINESIZE 200
COLUMN TRADE FORMAT A15
COLUMN datet FORMAT A15
COLUMN numb FORMAT A25
select trade, datet, numb from GTTDBO.TRADE ;
/
SPOOL OFF
SET serveroutput OFF
EXIT
Any advice. Its been driving me crazy
-
Originally Posted by ecomajor
select trade, datet, numb from GTTDBO.TRADE ;
/
SPOOL OFF
Take out the slash
Pablo (Paul) Berzukov
Author of Understanding Database Administration available at amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|