--創建陳述句
create table car(
name varchar2(50),--乘用車種類
conf varchar2(50) --配置指導單
)
--插入測驗資料
insert into car (NAME, CONF)
values ('SUV', '零件1');
insert into car (NAME, CONF)
values ('SUV', '零件3');
insert into car (NAME, CONF)
values ('SUV', '零件5');
insert into car (NAME, CONF)
values ('轎車', '零件1');
insert into car (NAME, CONF)
values ('轎車', '零件3');
insert into car (NAME, CONF)
values ('轎車', '零件5');
insert into car (NAME, CONF)
values ('轎車', '零件7');
insert into car (NAME, CONF)
values ('警車', '零件2');
insert into car (NAME, CONF)
values ('警車', '零件3');
insert into car (NAME, CONF)
values ('警車', '零件5');
insert into car (NAME, CONF)
values ('警車', '零件7');
--查詢源資料的效果如圖例2 期望效果.jpg 需要注意紅色文字的標準部分
select * from car order by name,substr(conf,3,1)
--期望的效果如
uj5u.com熱心網友回復：
如果零件數量有限并且可知，可以做。建議百度一下oracle縱轉橫uj5u.com熱心網友回復：
Oracle的 LISTAGG一個函式簡單搞定。SELECT deptno, LISTAGG(ename, ',') WITHIN GROUP (ORDER BY ename) AS employees
FROM emp
GROUP BY deptno
ORDER BY deptno;
DEPTNO EMPLOYEES
---------- ----------------------------------------
10 CLARK,KING,MILLER
20 ADAMS,FORD,JONES,SCOTT,SMITH
30 ALLEN,BLAKE,JAMES,MARTIN,TURNER,WARD
詳細參考：《Oracle 19c 中的 LISTAGG 函式詳解》
轉載請註明出處，本文鏈接：https://www.uj5u.com/shujuku/266072.html
標籤：開發