Home » SQL & PL/SQL » SQL & PL/SQL » rowid
rowid [message #36147] Wed, 07 November 2001 13:43 Go to next message
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 Go to previous messageGo to next message
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 Go to previous message
vn911
Messages: 2
Registered: November 2001
Junior Member
Thank you Todd. I'll give it a try.

----------------------------------------------------------------------
Previous Topic: procedure
Next Topic: Setting values on crash...
Goto Forum:
  


Current Time: Thu May 23 01:06:34 CDT 2024