原来一次插入多条记录是用这个方法,需要用到dual 表,
SQL> insert into tab_url(url)
2 select
3 'http://xxxxxxxx/d5yk/default.aspx1' from dual
4 union select
5 'http://xxxxxxxx/d5yk/default.aspx2' from dual
6 union select
7 'http://xxxxxxxx/d5yk/default.aspx3' from dual
8 union select
9 'http://xxxxxxxx/d5yk/default.aspx4' from dual
10 ;