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

Home -> Community -> Usenet -> c.d.o.tools -> PLSQL loop?

PLSQL loop?

From: Frank <franjoe_at_frisurf.no>
Date: Thu, 10 May 2001 00:03:46 +0200
Message-ID: <z9jK6.5991$Ty6.138688@news1.oke.nextra.no>

Hi!

You could make a little PLSQL with a loop that picks sequence_n.NEXTVAL until some reasonalble condition is reached. If the exact value of the sequences are of interest (I hope not) creating a script based on data dictionary/current values in the old database may be possible. Sadly not quite a "newbie task", but I haven't time to write one right now :-( If questionee post a request for it, I can give it a try tomorrow.

Frank, Received on Wed May 09 2001 - 17:03:46 CDT

Original text of this message

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