help

From: DK <dk_at_i7asia.com>
Date: Fri, 29 Jun 2001 02:07:02 -0700
Message-ID: <F001.0033D30E.20010629020619@fatcity.com>

Hi ,
I have a doubt in pl/sql.I want to insert 5 rows in a table.I want the user to be prompted for entering data 5 times. But this code prompts the user only one time and inserts 5 times.What should i do to achieve my expected behaviour?

declare
begin
for i in 1 .. 5
loop
insert into tmpc values(&no,&name,&mark); end loop;
end;
/

DK

--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: DK
  INET: dk_at_i7asia.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Received on Fri Jun 29 2001 - 04:07:02 CDT