Execute the below SQL statement if returns value the
string contains special character(characters apart from
those one listed in Translate statement).
SELECT *
FROM dual
WHERE
LENGTH(REPLACE(TRANSLATE(lower('STRING'),'asdfghjklqwertyuiopzxcvbnm1234567890',' '),' ',''))>0
those one listed in Translate statement).
SELECT *
FROM dual
WHERE
LENGTH(REPLACE(TRANSLATE(lower('STRING'),'asdfghjklqwertyuiopzxcvbnm1234567890',' '),' ',''))>0
No comments:
Post a Comment