Re: To find a just-inserted record

Replying Steve, Ed prochak:

On Fri, 21 Dec 2001, Steve 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.

On 21 Dec 2001, Ed prochak wrote:
>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/