Re: insert clause

Honglin Su <hosu_at_cs.umbc.edu> wrote in message news:37BD8586.24E8BA6D_at_cs.umbc.edu...
>
> Hi, there,
>
> When I use insert clause to insert a row to Oracle (by using JDBC), can
> I get a reference to that row which was just inserted? (Object reference
> or ROWID)
>
> Thank you!
>
> Honglin

In Oracle8, you can use a returning clause to get the rowid.

In Oracle7, you can use a after row-level trigger to get the rowid. For example,

create package MyPackage
as

    MyTableRowid rowid;
end;

create trigger MyTableTrigger
after insert on MyTable
for each row
begin

    MyPackage.MyTableRowid := :new.rowid; end;

then, you can refer MyPackage.MyTableRowid to get the rowid. Received on Sun Aug 22 1999 - 05:00:25 CDT