Re: using 10g express UI....

From: DA Morgan <damorgan_at_psoug.org>
Date: Wed, 09 May 2007 15:40:41 -0700
Message-ID: <1178750441.151223@bubbleator.drizzle.com>

user 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.
>
> Second, the 10g UI will only allow one statement at a time.
> Third, I can only open one UI window on my system at a time.

Not correct:

BEGIN

   INSERT INTO ...
   INSERT INTO ...
   INSERT INTO ...
   INSERT INTO ...

   UPDATE ...
   INSERT INTO ...
   INSERT INTO ...
   DELETE
   INSERT INTO ...
   INSERT INTO ...
   COMMIT;
END;
/

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org

Received on Wed May 09 2007 - 17:40:41 CDT