View Single Post

   
  #3 (permalink)  
Old 02-26-2008, 07:00 AM
valigula
 
Posts: n/a
Default Re: oracle 9i i=i+1??

On 27 mayo, 20:50, Valentin Minzatu <valentinminz...@yahoo.com> wrote:
> On May 27, 2:15 pm, valigula <valig...@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.

Reply With Quote