Home » SQL & PL/SQL » Client Tools » removing spaces between columns in sqlplus reports (oracle 10.2)
icon9.gif  removing spaces between columns in sqlplus reports [message #344075] Thu, 28 August 2008 13:11 Go to next message
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..



  • Attachment: sample.txt
    (Size: 0.22KB, Downloaded 476 times)
Re: removing spaces between columns in sqlplus reports [message #344509 is a reply to message #344075] Sat, 30 August 2008 02:19 Go to previous messageGo to next message
dr.s.raghunathan
Messages: 540
Registered: February 2008
Senior Member
hi,

please describe the table

yours
dr.s.raghunathan
Re: removing spaces between columns in sqlplus reports [message #344516 is a reply to message #344075] Sat, 30 August 2008 03:10 Go to previous message
Michel Cadot
Messages: 64139
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Trim the values, concatenate the fields.

Regards
Michel
Previous Topic: ORA-00600; internal error code (merged)
Next Topic: SP2-0223: No lines in SQL buffer
Goto Forum:
  


Current Time: Thu Dec 08 14:06:31 CST 2016

Total time taken to generate the page: 0.11738 seconds