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