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

Types of animations

Animation is a diverse and creative field with a variety of styles that artists and filmmakers use to bring their visions to life. Here are ...