sql insert of mult records

[drcab]

How would the syntax be for inserting multiple records into an Oracle db??

 

[culshaja]

Could you clarify this a bit more as its a bit vague?

James James Culshaw
jculshaw@active-data-solutions.co.uk

http://www.active-data-solutions.co.uk

http://www.brainbench.com/transcript.jsp?pid=193305

 

[drcab]

I have multiple records in a flat file that I want to push into an Oracle db. I know the insert command (but is there a way to insert multiple records? Here is an example of what we have for one but multiple records will not push.

insert into marine_personnel (
master_unit_list_number,
rank_id,
ssn,
im_marine_number,
last_name,
first_name,
middle_initial,
sex,
detached_master_unit_list_nbr,
capability_status_id,
service_code,
availability_status_id)
values ('27100','67','123456789','123456789','Shmo','Joe','R','M','14116','1','1','1');


Am I going to have to have an insert command for every record? Thank you for you time. Sorry for being so vague.

 

[culshaja]

Look at SQL*Loader. This is the Oracle utility for bulk loading text files into tables in Oracle. All the data has to go into the same table, and the data must be precisiely formatted i.e there must be the same amount of columns presented on each row of the text file. Its like the Access Import utility, or SQL Server DTS Import.

James James Culshaw
jculshaw@active-data-solutions.co.uk

http://www.active-data-solutions.co.uk

http://www.brainbench.com/transcript.jsp?pid=193305