Re: Remove non-integer Characters from a column

update table_name
set column_name = regexp_replace(column_name, ..., .....);

Need to be familiar with regular expressions though to get the most out of it.

HTH
Chris

On Thu, Jan 16, 2014 at 9:38 AM, Bala <oratips_at_gmail.com> wrote:

> 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