Oracle8i的左连接问题 放里面行不?A.fld1=substr(B.fld1(+),1,2); 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 select A.fld1, B.* from haha A ,(select * from haha where fld2='hehe' ) Bwhere A.fld1=substr(B.fld1(+),1,2); 或: select A.fld1, B.* from haha A left join (select * from haha where fld2='hehe' ) Bwhere A.fld1=substr(B.fld1,1,2); 更正:select A.fld1, B.* from haha A left join (select * from haha where fld2='hehe' ) Bon A.fld1=substr(B.fld1,1,2); select A.fld1, B.* from haha A ,(select * from haha where fld2='hehe' ) Bwhere A.fld1(+)=substr(B.fld1,1,2); 有关Oracle bfile数据类型的问题 创建存储过程中报:表达式i不能用做赋值目标 Oracle考试试题 ORACL 10G RAC 最近莫名其妙会很卡,ADDM查了出这种报告,什么意思啊? oracle 10g 首选身份证明有什么用啊? 请问,下面的SQL 语句执行效率最高,为什么? 分组后 相减操作的sql 请看题 数据库多对多建表是如何实现的? proc 中调用存储过程的一个问题 客户端装oracle9i,服务器装oracle8.0,字符显示问题,请看里面。 如何评估数据库容量. 函数想返回一个表的结果集,怎么写???急急急--在线等
select A.fld1,
B.*
from haha A ,(select * from haha where fld2='hehe' ) B
where A.fld1=substr(B.fld1(+),1,2);
select A.fld1,
B.*
from haha A left join
(select * from haha where fld2='hehe' ) B
where A.fld1=substr(B.fld1,1,2);
select A.fld1,
B.*
from haha A left join
(select * from haha where fld2='hehe' ) B
on A.fld1=substr(B.fld1,1,2);
B.*
from haha A ,(select * from haha where fld2='hehe' ) B
where A.fld1(+)=substr(B.fld1,1,2);