Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: create sequence in PL/SQL anonymous block - needs to be in se

RE: create sequence in PL/SQL anonymous block - needs to be in se

From: Cale, Rick T (Richard) <RICHARD.T.CALE_at_saic.com>
Date: Wed, 05 Sep 2001 06:36:34 -0700
Message-ID: <F001.003833C4.20010905063525@fatcity.com>

I do not know the history behind this thread but wouldn't this solution only work in a
single user system? I can see problems in a mult-user system.

Rick

-----Original Message-----
Sent: Wednesday, September 05, 2001 9:27 AM To: Multiple recipients of list ORACLE-L se

like Connor said, why use a sequence? you have a perfectly good sequence number in the loop index.
why waste the time of creating and dropping a sequence?

change your proc to:

> SQL> declare
> 2 i pls_integer ;
> 3 begin
> 5 for i in 1..1000
> 6 loop
> 7 insert into t (n)
> 8 values
> 9 (i) ; <=============== the only thing I changed.
> 10 end loop ;
> 11 commit ;
> 13 end ;
> 14 /

Tom Mercadante
Oracle Certified Professional

-----Original Message-----
Sent: Wednesday, September 05, 2001 5:23 AM To: Multiple recipients of list ORACLE-L separa

I'm not sure if what you've posted is just an example, but why not just do

insert into t select rowum from sys.source$ where rownum < 1000;

It's a lot quicker and easier

hth
connor


Connor McDonald
http://www.oracledba.co.uk (mirrored at http://www.oradba.freeserve.co.uk)

"Some days you're the pigeon, some days you're the statue"



Do You Yahoo!?
Get your free @yahoo.co.uk address at http://mail.yahoo.co.uk or your free @yahoo.ie address at http://mail.yahoo.ie
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: =?iso-8859-1?q?Connor=20McDonald?=
  INET: hamcdc_at_yahoo.co.uk

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).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Mercadante, Thomas F
  INET: NDATFM_at_labor.state.ny.us

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).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Cale, Rick T (Richard)
  INET: RICHARD.T.CALE_at_saic.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 Wed Sep 05 2001 - 08:36:34 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US