PL/SQL 查询
有没有大神帮忙看下怎样重复显示查询结果,直到条目数和列值相等。。。。比如
no. name type quantity
1 XXX A 5
显示成
no. name type quantity
1 XXX A 5
1 XXX A 5
1 XXX A 5
1 XXX A 5
1 XXX A 5
总共5行呢
2022-08-16 15:10
程序代码:
Select *
From tableA t,
(Select 1
From all_objects
Where rownum <= (Select quantity From tableA t Where Name = 'XXX')) t2
Where Name = 'XXX';
2022-08-16 16:56