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,
==
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 theexample 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-lReceived on Thu Jan 16 2014 - 16:38:40 CET