想要得到结果:
解决方案 »
- 执行完存储过程后执行SQL语句(SELECT)
- !!!紧急求救ORACLE高手,ORACLE中如何将数字转化为字符串
- 在线等?求log explorer 的oracle版本,需要恢复数据
- 除了游标还有什么办法可以循环表
- 用多线程写的JAVA类,查询Oracle数据库,但每执行一次,死链接就增加,大家帮帮忙!谢谢!
- 触发器问题:我如何在主表的新增触发器时,往从表中加入记录,并且根据加入从表记录的情况更改主表的标记位?
- 请问创建表的问题
- sql中的格式控制,怎样让不足两位的小数补成两位,整数部分不变?
- sql 可以多列的内容变成一列显示吗?
- c3p0 Timeout 超时问题 100分
- delete多条数据
- db2 函数
WITH cars AS
(SELECT '1' carid,'东风' carname, '11' driveraid, '12' driverbid FROM dual),
driver AS
(SELECT '11' driverid,1 carnum,'aaa' drivername FROM dual UNION
SELECT '12' driverid,1 carnum,'bbb' drivername FROM dual )
SELECT CARID,
CARNAME,
(SELECT DRIVERNAME || '(' || DRIVERID || ')'
FROM DRIVER K
WHERE K.DRIVERID = CARS.DRIVERAID
AND K.CARNUM = CARS.CARID),
(SELECT DRIVERNAME || '(' || DRIVERID || ')'
FROM DRIVER K
WHERE K.DRIVERID = CARS.DRIVERBID
AND K.CARNUM = CARS.CARID) FROM CARS
select '11' as driverid,'1' as carnum,'aaa' as drivername from dual
union all
select '12' as driverid,'1' as carnum,'bbb' as drivername from dual
),
car as (
select '1' as carid,'東風' as carname,'11' as driveraid,'12' as driverbid from dual
)
select a.carid,
a.carname,
b.drivername as driveraname,
c.drivername as driverbname
from car a
left join driver b on a.driveraid = b.driverid
and a.carid = b.carnum
left join driver c on a.driverbid = c.driverid
and a.carid = c.carnum