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

Home -> Community -> Usenet -> c.d.o.server -> Re: oracle 9i i=i+1??

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

From: valigula <valigula_at_gmail.com>
Date: 27 May 2007 12:44:54 -0700
Message-ID: <1180295094.551591.36820@q75g2000hsh.googlegroups.com>


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. Received on Sun May 27 2007 - 14:44:54 CDT

Original text of this message

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