can i run to to eliminate trailing
whitespaces. e.g. i have
'abc ' and want to update the table so any such
data is set without the
whitespace, in this case 'abc'
the fiels is varchar2
8.1.7.
cheers
--
Please see the official ORACLE-L FAQ:
http://www.orafaq.com
--
Author
Hi,
What query can i run to to eliminate trailing whitespaces. e.g. i have
'abc ' and want to update the table so any such data is set without the
whitespace, in this case 'abc'
the fiels is varchar2
8.1.7.
cheers
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author
Title: RE: whitespaces
use the rtrim function.
rtrim(char[,set]) - char, with final characters removed after the last character not in set. set defaults to ' '.
i.e.:
update table set field=rtrim(field);
Jon Baker
Database Architect
[EMAIL PROTECTED]
www.netsec.net
whitespaces. e.g. i have
'abc ' and want to update the table so any such data is set without the
whitespace, in this case 'abc'
the fiels is varchar2
8.1.7.
cheers
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author:
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858
: Thursday, February 14, 2002 9:08 AM
To: Multiple recipients of list ORACLE-L
Hi,
What query can i run to to eliminate trailing whitespaces. e.g. i have
'abc ' and want to update the table so any such data is set without the
whitespace, in this case 'abc'
the fiels is varchar2
8.1.7.
cheers