Re: oracle 9i i=i+1??

On May 27, 11:44 pm, valigula <valig..._at_gmail.com> wrote:
> On 27 mayo, 20:50, Valentin Minzatu <valentinminz..._at_yahoo.com> wrote:
>
> > On May 27, 2:15 pm, valigula <valig..._at_gmail.com> wrote:
>
> > > Hi all,
> > > It is any function in Oracle 9i equal o with a similar
> > > funtionability than (i=i+1).
> > > I want to do a "Insert Into a select" but one fileds is a counter ...
>
> > > Thanks in advance ..
> > > A.
>
> > I am not very clear on the question, but I guess you can use ROWNUM, a
> > sequence or implement your own function. Maybe others have more ideas.
>
> Thanks for your respond i have a function that already does it. But it
> is to resource/time consuming, therefore i am trying to do it on the
> fly.
> And i can not use the rownum since i will need to start from the
> value 53425...this number should be increase by one in every row
> insert.
>
> A.

Research SEQUENCEs and BEFORE INSERT FOR EACH ROW triggers. Oracle doesn't support 'identity'/autoincrement columns.

Hth,

   Vladimir M. Zakharychev
   N-Networks, makers of Dynamic PSP(tm)    http://www.dynamicpsp.com Received on Sun May 27 2007 - 15:06:32 CDT