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行呢
Select * From tableA t, (Select 1 From all_objects Where rownum <= (Select quantity From tableA t Where Name = 'XXX')) t2 Where Name = 'XXX';