Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Find certain characters in table with regexp_like

Eduardo Ponce de LeonJul 19 2024 — edited Jul 19 2024

How do i use the regexp_like to search for certain characters. Suppose I want to find the below characters

¶ ֠ä§Â¯¬²³â±

If I do this, i am not getting the expected results

select name from TCR_HUB.c_xout_xorg where regexp_like(name, '[¶ ֠ä§Â¯¬²³â±]');

The expected result is the get a list of any name that contain any of this characters.

What am I doing wrong?

This post has been answered by Paulzip on Jul 23 2024
Jump to Answer
Comments
Post Details
Added on Jul 19 2024
11 comments
476 views