select '/' || nvl(11.name, '') || '/' || nvl(12.name, '') || '/' ||
nvl(13.name, '') || '/' || nvl(14.name, '')
from direct 11, direct 12, direct 13, direct 14
where 11.id = 12.parentid(+)
and 12.id = 13.parentid(+)
and 13.id = 14.parentid(+)
and 11.id = 1
order by 11.name, 12.name, 13.name, 14.name
大家帮忙看看这个sql错误
nvl(13.name, '') || '/' || nvl(14.name, '')
from direct 11, direct 12, direct 13, direct 14
where 11.id = 12.parentid(+)
and 12.id = 13.parentid(+)
and 13.id = 14.parentid(+)
and 11.id = 1
order by 11.name, 12.name, 13.name, 14.name
大家帮忙看看这个sql错误
解决方案 »
- Oracle开发中局部索引与全局索引有什么作用和区别
- oracle分页查询报错,FROM关键字未找到!求帮助!
- oracle RAC中vip的作用?
- 问个弱弱的问题:看到有的资料上提到"INTERNAL/SYS"帐号,它和常说的SYS帐号是同一回事吗?
- 求一个简单的存储过程
- crontab环境变量如何设置
- dba_tables 为什么不能查询呢?
- oracle里blob类型和clob类型迷惑
- SQL中有时候出现的(+)代表什么意思?最好能有例子说明,谢谢
- kettle求助: 抽取数据时连接重置Connection reset
- 求教:count及group by应用
- Oracle11 安装后找不到Enterprise Manager Console
这样就可以了
select '/' || nvl(a.name, '') || '/' || nvl(b.name, '') || '/' ||
nvl(c.name, '') || '/' || nvl(d.name, '')
from direct a, direct b, direct c, direct d
where a.id = b.parentid(+)
and b.id = c.parentid(+)
and c.id = d.parentid(+)
and a.id = 1
order by a.name, b.name, c.name, d.name