Oracle如何将一个字段的每一条数据添加为一个新字段

Question

要求用 table_1 的数据，生成 table_2

Answer 1

with
test_tab(num1,desc1,num2,desc2) as 
(
select '1','master','111','AAA' from dual union all
select '2','slave','222','BBB' from dual union all
select '2','slave','333','CCC' from dual union all
select '2','slave','444','DDD' from dual 
)
select num2,desc2,(select num2 from test_tab where num1=2 and rownum <2),(select desc2 from test_tab where num1=2 and rownum<2), 
(select num2 from (select rownum rum,num2 from test_tab where num1=2 and rownum<3)where rum>1),
(select desc2 from (select rownum rum,desc2 from test_tab where num1=2 and rownum<3)where rum>1),
(select num2 from (select rownum rum,num2 from test_tab where num1=2 and rownum<4)where rum>2),
(select desc2 from (select rownum rum,desc2 from test_tab where num1=2 and rownum<4)where rum>2)
from test_tab where num1=1;


NUM DES (SE (SE (SE (SE (SE (SE
--- --- --- --- --- --- --- ---
111 AAA 222 BBB 333 CCC 444 DDD