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
at erp, erp, oracleapps, oracleapps erp, oracle erp, oracle ebusiness, oracle application,
about oracle, oracle developer, oracle jobs, finance software, finance accounting accounting, r12 oracle
those one listed in Translate statement).
SELECT *
FROM dual
WHERE
LENGTH(REPLACE(TRANSLATE(lower('STRING'),'asdfghjklqwertyuiopzxcvbnm1234567890',' '),' ',''))>0
at erp, erp, oracleapps, oracleapps erp, oracle erp, oracle ebusiness, oracle application,
about oracle, oracle developer, oracle jobs, finance software, finance accounting accounting, r12 oracle
2 comments:
This is what I am looking for since days ago. Thanks for posting such kind of information regards PL/SQL.
Best Online Software Training Institute | PL/SQL Training
Oracle Apps R12 and Fusion Cloud Self Paced Training Videos by Industry Experts. Please Check https://www.oracleappstechnical.com
Post a Comment