Re: Auto generating Sequences !!

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Mon, 10 Apr 2006 23:29:56 +0200
Message-ID: <kdjl32pspcjtqi3r31usju9ph20ta7mnob@4ax.com>

On 10 Apr 2006 11:01:08 -0700, "chani" <chanakam2000_at_gmail.com> wrote:

>Yes I wan to create sequence for each record, The sequence will not
>have only one value.
>ex:
> seq_loan001 will have values payment_001,payment_002,...
>
> & so on ,as same
> seq_loan002 will also have values payment_001,payment_002,...
>
>Can you please help me for do this.

I'm very much in favor of learning people to fish, instead of spoonfeeding them. I already provided you with execute immediate
and the autonomous transaction concept.
They are not that difficult to look up in the doco.

That said, I wonder why starting people are so lazy nowadays. When I started the only thing I had was a collection of books. There was no www and no acccess to Usenet.

--
Sybrand Bakker, Senior Oracle DBA

Received on Mon Apr 10 2006 - 16:29:56 CDT