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

From: <karsten_schmidt8891_at_my-deja.com>
Date: Fri, 05 Nov 1999 10:29:05 GMT
Message-ID: <7vubhh$d3e$1@nnrp1.deja.com>

Hi,

oracle 7:

SQL> create table tab (col number primary key);

Table created.

SQL> create or replace trigger mytrig
  2 after insert on tab
  3 for each row
  4 begin
  5 dbms_output.put_line(:new.rowid);   6 end;
  7 /

Trigger created.

SQL> set serverout on
SQL> insert into tab values (1);
00076A9F.0000.0002

1 row created.

this should not be different on oracle 8 /8.1 (apart from rowid format.)

HTH
Karsten

In article <3821F8ED.BE12B948_at_yahoo.com>, Carlos <dpafumi_at_yahoo.com> wrote:
> 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.
>
> Thanks
> Carlos
>
>

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Fri Nov 05 1999 - 04:29:05 CST