高手请进,一个简单的问题!!! select a.* from a where not exists(select 1 from b where b.id=a.id); 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 select * from A where id no in (select id from B where A.id=B.id) sorryselect * from A where id not in (select id from B where A.id=B.id) select * from from a where a.id not in (select id from b); select a.id from (select a.id,b.id from a,b where a.id = b.id(+))where b.id is null; select a.id from (select a.id,b.id from a,b where a.id = b.id(+))where b.id is null; select a.*from a,bwhere a.id = b.id(+) and b.id is null 求一存储过程 悲哀呀,数据表删不了? 把mysql分页代码转成oracle,谢谢 有用过 oracle sqldevloper 工具的吗 oracle服务器上删除数据库? unix下 oralce 8.0.5 连接unix 下8.1.6的问题 存储过程问题,请问如何才能使用一个变量参数作为表名? 有哪位高手谁知道在pro*c中怎样把数据插入oracle中blob类型的字段中? 焦头烂额:如何使用BC对oracle的Blob字段进行操作 怎样监视oracle的操作(如用日志信息) 如何将文本文件导入oracle ORACLE的存储过程中能读写文件吗?
where a.id not in (select id from b);
where b.id is null;
where b.id is null;
from a,b
where a.id = b.id(+)
and b.id is null