Hi,I want to get rid or
those special char in a number string to a pure number, for an instance, from
89_. or 99,9 to 89 and 999.Which function should I use in SqlPlus?Thanks
a lot,
Jack
Change nuber.+# to
number
Does it make a deal?
SQL select translate('#33',
'1234567890#,_', '1234567890') from
dual;
TR--33
-Original Message-From: Liu, Jack
[mailto:[EMAIL PROTECTED]Sent: Thursday, July 31, 2003 2:10
PMTo: Multiple recipients of list ORACLE-LSubject:
Change nuber.+# to number
: Thursday, July 31, 2003 12:10 PM
To: Multiple recipients of list ORACLE-L
Hi,
I want to get rid or those special char in a number string to a pure number,
for an instance, from 89_. or 99,9 to 89 and 999.
Which function should I use in SqlPlus?
Thanks a lot,
Jack
Change nuber.+# to number