Re: Expertise Requires With Data Extraction

From: Michel Cadot <micadot{at}altern{dot}org>
Date: Tue, 1 Nov 2005 19:34:26 +0100
Message-ID: <4367b567$0$7350$636a55ce@news.free.fr>

<fgj001_at_yahoo.com> a écrit dans le message de news: 1130865840.148605.86480_at_z14g2000cwz.googlegroups.com...
| rtrim seems like have a bug -
|
| SQL> select rtrim('POSITION_DATA_A_V','_A_V') from dual;
|
| POSITION_DAT
|
| SQL>
|
| an extra 'A' was removed.
|

Reread the definition of RTRIM:
http://download-west.oracle.com/docs/cd/B10501_01/server.920/a96540/functions109a.htm#1018969

<quote>
RTRIM(char,set)
RTRIM returns char, with all the rightmost characters that appear in set removed... </quote>

"characters that appear in set" not "string".

Regards
Michel Cadot Received on Tue Nov 01 2005 - 12:34:26 CST