Re: Get rownum or rowid in insert URGENTT!!!!

From: Peter Laursen <ptl_at_edbgruppen.dk>
Date: 5 Nov 1999 08:51:09 GMT
Message-ID: <01bf2773$fa2256e0$2c289a0a@apollo>

Carlos <dpafumi_at_yahoo.com> skrev i artiklen <3821F8ED.BE12B948_at_yahoo.com>...
> Hi!
>
> I need something very Urgent!!
> I am making severals inserts in a table, for each one I need to get the
> rowid or rownum . How to do it?
> I tried with a trigger, but it didn't work. Any suggestion?
> I don't know in which moment the client is going to make an insert,
> that's why I need these, to identified that row.

insert into table
values(...)
returning rowid into my_var

Is this what you need?

Peter Received on Fri Nov 05 1999 - 02:51:09 CST