Remove non-integer Characters from a column

From: Bala <oratips_at_gmail.com>
Date: Thu, 16 Jan 2014 09:38:40 -0600
Message-ID: <CAF5SaXtEBK-aXnYK5A3Wt3q9behViZRewNaWMcqvhcv9U1JqUg_at_mail.gmail.com>



Gurus,

Oracle 11..2.0.3 on Linux R6
==

1) I have a field with a data type of varchar2 that has integers and non-integer characters.

2) Example: 214’ or 61+45 or 88/8.
3) How can i remove the non-integer characters from the table ?
4) Can a function be written to remove non-integer characters ?, so in the
example it would be 214 or 6145 or 888
==

Appreciate any pointers to solve this, thank you in advance.

Sincerely

-- 
Bala Rao

--
http://www.freelists.org/webpage/oracle-l
Received on Thu Jan 16 2014 - 16:38:40 CET

Original text of this message