Remove non-integer Characters from a column
- From: Bala <oratips@xxxxxxxxx>
- To: oracle-l <oracle-l@xxxxxxxxxxxxx>
- Date: Thu, 16 Jan 2014 09:38:40 -0600
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
Other related posts:
