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).

FROM   dual
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


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

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 for Never Before Offers and Discount Coupon Codes.