Re: To find a just-inserted record
From: S P Arif Sahari Wibowo <arifsaha_at_yahoo.com>
Date: Fri, 21 Dec 2001 12:54:57 -0600
Message-ID: <Pine.LNX.4.42.0112211242460.28418-100000_at_macbeth.tirone.com>
Date: Fri, 21 Dec 2001 12:54:57 -0600
Message-ID: <Pine.LNX.4.42.0112211242460.28418-100000_at_macbeth.tirone.com>
Replying Steve, Ed prochak:
On Fri, 21 Dec 2001, Steve wrote:
On 21 Dec 2001, Ed prochak wrote:
>insert into MY_TABLE values (..................) returning rowid into
>MY_ROWID_VARIABLE
Hey, great! This is what I am looking for. Somehow I missed it earlier.
Thanks.
>here's a hint: think PRIMARY KEY.
This solution have some diffculties:
- It require the table to have unique non null primary key. Not all table
have primary key.
- It require either the primary key is in predictable sequence, or the primary key to be generated before insert, which not always easy to do.
Thanks, though.
-- S P Arif Sahari Wibowo _____ _____ _____ _____ /____ /____/ /____/ /____ arifsaha_at_yahoo.com _____/ / / / _____/ http://www.arifsaha.com/Received on Fri Dec 21 2001 - 19:54:57 CET