Wednesday, November 7, 2012

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




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

3 comments:

Unknown said...

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

rajeev said...

Oracle Apps R12 and Fusion Cloud Self Paced Training Videos by Industry Experts. Please Check https://www.oracleappstechnical.com

Smith said...

Oracle Apps R12 and Oracle Fusion Cloud Self Paced Online Training Videos Published on Udemy with Life Time Access & Live Meeting Support to Clear your Queries. Avail 25% to 80% discount. Please Check https://www.oracleappstechnical.com for Never Before Offers and Discount Coupon Codes.