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
4 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
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
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
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!
Post a Comment