ORACLE 11G cf ORACLE 10 G
1 select * from A where A.name like 'TEST';
上面的SQL 不能查出任何结果
===>select * from A where A.name = 'TEST';
2 SELECT * FROM B
WHERE B.NAME not like 'b2';
===========>无效限定符 应该修改为
SELECT * FROM B
WHERE B.NAME != 'b2';
1 select * from A where A.name like 'TEST';
上面的SQL 不能查出任何结果
===>select * from A where A.name = 'TEST';
2 SELECT * FROM B
WHERE B.NAME not like 'b2';
===========>无效限定符 应该修改为
SELECT * FROM B
WHERE B.NAME != 'b2';