Oracle SQL -如何插入多个记录

Question

我需要为50个不同的记录插入以下值“1)至”150)。如何将下面的内容缩短为一行？

insert into p.p_assumptions (p_number, value) values (11, '1)');
insert into p.p_assumptions (p_number, value) values (11, '2)');
...
insert into p.p_assumptions (p_number, value) values (11, '150)');

Answer 1

一种方法是使用connect by子句。

insert into p_assumptions (p_number, value) 
select 11, level || ')'
from dual
Connect by level <= 150;

Answer 2

一个简单的方法:拿一张至少有150条记录的桌子。然后

insert into p_assumptions (p_number, value) 
select 11, to_char(rownum) || ')'
from table_with_at_least_150_records
where rownum <= 150;