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
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