SQL> select count(*) from tab where tname like '%BIN%';
COUNT(*)
----------
370
Elapsed: 00:00:00.07
SQL>
2)小写
SQL> select count(*) from tab where tname like '%bin%';
COUNT(*)
----------
0
Elapsed: 00:00:00.06
SQL>
no rows selected
doudou@TEST> select count(*) from user_tables where table_name='DOUDOU_TEST2';
COUNT(*)
----------
1
doudou@TEST> select count(*) from doudou_test2 where name like 'doudou+小写';
COUNT(*)
----------
1
Elapsed: 00:00:00.00
doudou@TEST> select count(*) from doudou_test2 where name like 'DOUDOU+小写';
COUNT(*)
----------
0
Elapsed: 00:00:00.00
doudou@TEST> select * from doudou_test2;
ID NAME
---------------------------------------- ----------------------------------------
1 doudou+小写
2 DOUDOU+大写
Elapsed: 00:00:00.01