Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Please ask technical questions in the appropriate category. Thank you!

Find special characters in sequence

pranav shahMay 20 2024

I would like your inputs pls for alternative methods of finding special characters from a string.

String :

(Mysubject.class[math]:{grade}.[pass])

So first I need to find if special characters are in order

(.[]:{}.[])

Above is correct but if we have something like below

(.[:{}.[]) — missing [

(.[]:{}[]) — missing .

Which is not correct as ] is missing.

We can do it using IF clause but is there any alternate method by which we can identify if sequence is not correct raise error.

Comments
Post Details
Added on May 20 2024
2 comments
148 views