DB version:11.2.0.2
How can I search for strings with dollar character in it?
create table test123 (empname varchar2(25));
insert into test123 values ('JOCE$LN');
insert into test123 values ('KAT$LN');
insert into test123 values ('MANA$BVG');
SQL> select * from test123;
EMPNAME
-------------------------
JOCE$LN
KAT$LN
MANA$BVG
SQL> select * from test123 where empname like 'JOCE\$E';
no rows selected
SQL> select * from test123 where empname like 'JOCE\$L%' escape '\';
select * from test123 where empname like 'JOCE\$L%' escape '\'
*
ERROR at line 1:
ORA-01424: missing or illegal character following the escape character
SQL> select * from test123 where empname like 'JOCE\$%' escape '\';
select * from test123 where empname like 'JOCE\$%' escape '\'
*
ERROR at line 1:
ORA-01424: missing or illegal character following the escape character