On 9 May, 22:57, user <some..._at_someplace.org> wrote:
> Trying to insert multiple rows. Have determined Oracle 10g UI will
> require me to enter only one row at a time as following:
>
> insert into committee (cccb_id, com_name) values (500 ,'Historic
> Preservation Commission');
> then next row
>
> insert into committee (cccb_id, com_name) values (550 ,'Improvements and
> Service Committee');
> then next row
>
> insert into committee (cccb_id, com_name) values (600 ,'Mayors
> Beautification Committee');
> then next row
>
> First, is this correct. The insert statement will allow only one row at
> a time.
Correct. One INSERT statement inserts one row. As documented here:
http://download-uk.oracle.com/docs/cd/B19306_01/server.102/b14200/statements_9014.htm#i2163698
Received on Thu May 10 2007 - 05:42:48 CDT
