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

6 comments:

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

    ReplyDelete
  2. Great post! I really like how you explained the topic in a clear and practical way. For anyone looking to build strong technical skills, this Embedded Systems Course In Hyderabad can be a valuable option to gain hands-on experience. Thanks for sharing such useful insights!

    ReplyDelete
  3. The way this post connects AI concepts with real educational challenges shows strong subject knowledge.
    Guidewire Course In Hyderabad

    ReplyDelete
  4. The coding exercises were practical and well-explained. I learned so much by following along step by step.
    Generative AI Training In Hyderabad

    ReplyDelete