67,512
社区成员
发帖
与我相关
我的任务
分享
SQL> select b.ffid,
2 b.ffno,
3 (select a.fhno
4 from Thardware a
5 where a.ffid = b.ffid
6 and a.fxmname = '内存') as 内存,
7 (select a.fhno
8 from Thardware a
9 where a.ffid = b.ffid
10 and a.fxmname = 'cpu') as cpu,
11 (select a.fhno
12 from Thardware a
13 where a.ffid = b.ffid
14 and a.fxmname = '硬盘') as 硬盘
15 from Tfacility b
16 ;
FFID FFNO 内存 CPU 硬盘
---------- -------------------------------------------------- -------------------------------------------------- -------------------------------------------------- --------------------------------------------------
1 pc-001 内存-001 cpu-001 硬盘-001
2 pc-002 内存-002 cpu-002 硬盘-002
3 pc-003 内存-003 cpu-003 硬盘-003
SQL>
SQL> select ffno, wmsys.wm_concat(fhno)
2 from (select * from Thardware a, Tfacility b where a.ffid = b.ffid order by fxmname)
3 group by ffno
4 ;
FFNO WMSYS.WM_CONCAT(FHNO)
-------------------------------------------------- --------------------------------------------------------------------------------
pc-001 cpu-001,内存-001,硬盘-001
pc-002 cpu-002,内存-002,硬盘-002
pc-003 cpu-003,内存-003,硬盘-003
SQL>