求一条查询语句 select a.*,b.code,b.name from a,b where a.partid=b.partid(+); 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 是这样吗,第一师的所有士兵:select b.*,(select id from a start with id = 2 connect by prior id = parentid) cwhere b.partid = a.id duanzilin(寻)你的语句少了From,执行不通 不好意思select b.* from b,(select id from a start with id = 2 connect by prior id = parentid) cwhere b.partid = a.id select b.* from b,(select id from a start with id = 2 connect by prior id = parentid) cwhere b.partid = C.id这样才正确 高分求关于递归查询的oracle语句! oracle 把整数转换成固定格式的日期,谢谢 请问oracle中如何查看一个数据块中的所有锁的锁ID sql列转行(在线等) 数据一次库错误,第二次正确。 求一SQL语句 求:去掉字符串右边的数字,如:'城北区建设路78'->'城北区建设路' sql脚本导入oracle OracleConnection 连接ORACLE数据库的字符串如何写?? oracle8.1.7的问题,请帮忙,多谢!! 请问ORACLE里有没有类似于MS SQL里面的数据导入工具的东西? 关于向分区表中插入数据的问题,请高手指教?
select b.*,
(select id from a start with id = 2 connect by prior id = parentid) c
where b.partid = a.id
你的语句少了From,执行不通
select b.* from b,
(select id from a start with id = 2 connect by prior id = parentid) c
where b.partid = a.id
(select id from a start with id = 2 connect by prior id = parentid) c
where b.partid = C.id
这样才正确