OraFAQ Forum: Client Tools » removing spaces between columns in sqlplus reports

Home » Other » Client Tools » removing spaces between columns in sqlplus reports (oracle 10.2)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

removing spaces between columns in sqlplus reports [message #344075]

Thu, 28 August 2008 13:11

mohapatra
Messages: 24
Registered: August 2006
Location: New Jersey

Junior Member

Hi All,
Can you please guide me.

I m getting lots of spaces betwen columns . I want , no space between them. How can i achieve that.

I have used all the formatting options.yet it doesnt work..

SET FEEDBACK OFF
SET PAGESIZE 0
SET SPACE 0
SET HEADING OFF
SET LINESIZE 200
SET TERMOUT OFF
SET RECSEP OFF
SET TRIMSPOOL ON

below is one sample line..