Oracle sql*plus

Comment by Santosh on October 19, 2011 at 3:51am

Plz try this query,

This query is helpful to search a word having underscore within that word.

select * from emp_main_dtls emd where emd.first_name like '%\_%' escape '\';

Comment by subramanian on October 28, 2011 at 9:48pm

thanks,

 yes your are right.

Comment by Asadullah fazli on October 31, 2011 at 2:17pm

Thank ur all for helping me

Comment