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.

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.

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.

On May 27, 11:44 pm, valigula <valig...@gmail.com> wrote:
> 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.

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

On 27 mei, 22:06, "Vladimir M. Zakharychev"
<vladimir.zakharyc...@gmail.com> wrote:
> On May 27, 11:44 pm, valigula <valig...@gmail.com> wrote:
>
>
>
> > 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.
>
> 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

insert into tbl2
select rownum+53424, fielda,fieldb from tbl2

On 28 mayo, 09:29, ryck...@gmail.com wrote:
> On 27 mei, 22:06, "Vladimir M. Zakharychev"
>
>
>
> <vladimir.zakharyc...@gmail.com> wrote:
> > On May 27, 11:44 pm, valigula <valig...@gmail.com> wrote:
>
> > > 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.
>
> > 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
>
> insert into tbl2
> select rownum+53424, fielda,fieldb from tbl2

thanks that is what i was looking for.
Regards

A.