Skip to Main Content
Forums

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Translate functions

702144May 18 2009 — edited May 18 2009
I am trying to exclude all the numeric values from a column selection using translate, but it is not working out, Please help. Below is the query I used.


1 select password, TRANSLATE(password, '0123456789', '0123456789') tns
2 from
3 my_data
4 where
5* NOT TRANSLATE(password, '0123456789','123456789') > 0
SQL> /
NOT TRANSLATE(password, '0123456789','123456789') > 0
*
ERROR at line 5:
ORA-01722: invalid number
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jun 15 2009
Added on May 18 2009
6 comments
514 views