Re: Rowid after an insert???

From: Wayne Linton <lintonw_at_cadvision.com>
Date: 1996/09/11
Message-ID: <323656AC.8F6_at_cadvision.com>#1/1

Steve Cosner wrote:
>
> I need to know the rowid of a single row that I have just inserted. I
> have searched through all the Oracle documentation that I have, and
> can't find anything even close.

Have you tried PL/SQL AFTER INSERT trigger on the table? I think the ROWID might be had via the :new.ROWID? Give it a try.

Wayne Linton Received on Wed Sep 11 1996 - 00:00:00 CEST

This message: [ Message body ]
Next message: David John Hazledine: "Re: Rowid after an insert???"
Previous message: Keith Majkut: "Re: Installing 16 bit version of SQL*NET"
In reply to: Steve Cosner: "Rowid after an insert???"
In reply to Brian Martin: "Executing the contents of a variable as a PL/SQL statement"
Next in thread: David John Hazledine: "Re: Rowid after an insert???"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message