SQL*Plus question: set linesize nnnnn?
From: <al_dev_at_candle.com>
Date: 1996/04/25
Message-ID: <4louqf$hjt_at_phobos.Candle.Com>#1/1
Date: 1996/04/25
Message-ID: <4louqf$hjt_at_phobos.Candle.Com>#1/1
How do I avoid unwanted spaces after the fields as in the case below -
File j.sql is as follows:
set tab off;
set linesize 1000;
select table_name from dict where table_name='V$LOCK';
quit;
unixprompt> sqlplus sys/password _at_j.sql > j.out
in j.out I find extra spaces upto line size 1000 chars. I need to use tab off to avoid tabs and set trimout on does not work as per User guide......
thanks
al
Received on Thu Apr 25 1996 - 00:00:00 CEST