| 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
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
