Oracle Application Help Line
By Shekhar Nema
Tuesday, August 11, 2009
Query to Find Unwanted Characters
select addr_line_1 from table_name
where translate(upper((trim(addr_line_1))),
CHR(0)||' QWERTYUIOPASDFGHJKLZXCVBNM ,.<>/?;:''"[{]}1234567890-=!@#$%^&*()_+\|`~ \n'),
CHR(0)
) IS NOT NULL
No comments:
Post a Comment
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment