On 27 mei, 22:06, "Vladimir M. Zakharychev"
<vladimir.zakharyc..._at_gmail.com> wrote:
> 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
insert into tbl2
select rownum+53424, fielda,fieldb from tbl2
Received on Mon May 28 2007 - 02:29:19 CDT
