Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: oracle 9i i=i+1??
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