How to identify special character in your string.
SELECT *
FROM dual
WHERE
LENGTH(REPLACE(TRANSLATE(lower('chalam'),'asdfghjklqwertyuiopzxcvbnm1234567890',''),' ',''))>0
If it display null value there is no special character in your string
If it display X value there is special character in your string
SELECT *
FROM dual
WHERE
LENGTH(REPLACE(TRANSLATE(lower('chalam'),'asdfghjklqwertyuiopzxcvbnm1234567890',''),' ',''))>0
If it display null value there is no special character in your string
If it display X value there is special character in your string
No comments:
Post a Comment