rowid [message #36147] |
Wed, 07 November 2001 13:43 |
vn911
Messages: 2 Registered: November 2001
|
Junior Member |
|
|
Hi,
Is there any way to get the rowid of the newly inserted row without doing a "select ROWID into ..."
Thanks
----------------------------------------------------------------------
|
|
|
Re: rowid [message #36148 is a reply to message #36147] |
Wed, 07 November 2001 15:37 |
Todd Barry
Messages: 4819 Registered: August 2001
|
Senior Member |
|
|
declare
r rowid;
begin
insert into t values (1)
returning rowid into r;
end;
----------------------------------------------------------------------
|
|
|
Re: rowid [message #36166 is a reply to message #36148] |
Thu, 08 November 2001 07:35 |
vn911
Messages: 2 Registered: November 2001
|
Junior Member |
|
|
Thank you Todd. I'll give it a try.
----------------------------------------------------------------------
|
|
|