| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: TRIM seems to not work...
If you are only selecting 1 field, then yes, ORACLE by default pads the
line with spaces to the LINESIZE parameter.
-----Original Message-----
From: Rocky Welch [SMTP:rockyw_99_at_yahoo.com] Sent: Friday, January 19, 2001 4:06 PM To: Multiple recipients of list ORACLE-L Subject: TRIM seems to not work...
Hi Gang,
HAPPY FRIDAY!
I'm having a problem with the trim function on 8.1.6 running on Solaris 8.
Here is the code:
spool /export/home/mp5i/r5prompts/input/user.txt;
select TRIM(TRAILING ' ' FROM usr_code)
from r5users;
spool off;
When I edit the file produced there are trailing blanks after the data. Am I missing something here? I just want the data without the trailing blanks afterward.
TIA,
-Rocky
 |
 |