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

4 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

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.

vijay said...

This is the best place where I have found good stuff regarding jobs what I required. Thanks for sharing the useful jobs and please do keep updating...
Salesforce Training in Chennai

Salesforce Online Training in Chennai

Salesforce Training in Bangalore

Salesforce Training in Hyderabad

Salesforce training in ameerpet

Salesforce Training in Pune

Salesforce Online Training

Salesforce Training

VISWA Online Trainings said...

Hi.., Excellent websites you possess at this time there.

Selenium with Python Self-Placed Training Videos
SAP QM Certification Online Training from Hyderabad
Powershell Online Training from India
Windows Server Training
PHP Realtime Online Support In India
Apache Spark Free Live Online Demo Class
RPA Interview Questions & Answers