SQL create table test(a varchar2(10));
Table created.
SQL insert into test values('鸟');
1 row created.
SQL commit;
Commit complete.
SQL insert into test values('深刻');
1 row created.
SQL commit;
Commit complete.
SQL insert into test values('aaa');
1 row created.
SQL insert into test values('bbb');
1 row created.
SQL commit;
Commit complete.
SQL select a from test;
A
----------
鸟
深刻
aaa
bbb
SQL select a from test where asciistr(a) like '%\%';
A
----------
鸟
深刻
SQL select a from test where asciistr(a) not like'%\%';
A
----------
aaa
bbb
