How to import big out resource data

Posted on | Edited on | In

For example, when a sheet have about 1 million record need import in to database.
How to do this.

1
2
3
4
5
6
7
insert into zoo_sea (id, name, age, birthday, status)
  select 1, 'dog', '2017-05-01', 1 from dual
union all select 2, 'dog', '2017-05-02', 2 from dual
union all select 3, 'dog', '2017-05-03', 1 from dual
union all select 4, 'dog', '2017-05-04', 3 from dual
union all select 5, 'dog', '2017-05-05', 2 from dual
...

make 1 million data into 10000 sql command, insert can finish with in 20 minutes.