Monday, January 30, 2017

PLSQL: Identify special characters in the string


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


No comments:

Post a Comment

How to improve blog performance

Improving the performance of a blog can involve a variety of strategies, including optimizing the website's technical infrastructure, im...