escape的使用

escape的使用
SQL> select * from morg;

        ID NAME                          AGE BIRTHDAY
---------- ---------------------- ---------- ----------
           a/fdsa
           a/f%sa
           af%sa
           _a/f%sa
           _af%sa
           b_af%sa
           bc_af%sa
           ca/f%sa
           ba/f%sa

已选择9行。


SQL> select * from morg where name like '_a%';

        ID NAME                          AGE BIRTHDAY
---------- ---------------------- ---------- ----------
           _a/f%sa
           _af%sa
           ca/f%sa
           ba/f%sa


SQL> select * from morg where name like '/_a%' escape '/';

        ID NAME                          AGE BIRTHDAY
---------- ---------------------- ---------- ----------
           _a/f%sa
           _af%sa