ESCAPE With LIKE Operator
select ename from scott.emp where ename like '%_%';
But you will be surprised to see the results:
ENAME
------------
Will dispaly all Data in the Table
it is because _ is a wild card character. That is _ stands for any character. So the query yielded all the rows.
modified query to get the desired output as below:
select ename from scott.emp where ename like '%#_%' escape '#';
ENAME
------------
FRA_KLIN
No comments:
Post a Comment