Home » Other » Client Tools » Formatting sqlplus output
Formatting sqlplus output [message #25960] Wed, 28 May 2003 13:32
Val
Messages: 12
Registered: March 2002
Junior Member
I need to get sqlplus output of VARCHAR(n) fields applying SUBSTR() function:

SQL> select field1 , substr(field2,1,1) , substr(field3,1,1)
2 from some_table;

The output shows first charachter for field2 and field3 (as expected) with the following spaces which I need to trim off. Same problem for the header and dashed line dividing header from report body:

FIELD1 FIELD2 FIELD3
---------- -------------- --------

Please, help!!!

Thanks,
Val
Previous Topic: Concatenate 2 rows with a condition
Next Topic: Needed urgent
Goto Forum:
  


Current Time: Thu Mar 28 15:47:14 CDT 2024