Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Q: INSERT, UPDATE and how to catch rowid

Re: Q: INSERT, UPDATE and how to catch rowid

From: kumarg <x_at_x.com>
Date: 1997/09/25
Message-ID: <01bcc9e8$dcd259e0$9ef67fc0@gaatlakumarg.atlantaga.ncr.com>#1/1

You are right, except for one small correction. Once the rowids are assigned they do not change unless the table is recreated. So on a update the rowid is the same old and new. On a delete the old rowid can be got by using PL/SQL so update and delete need not have trigger solution as you had proposed. Received on Thu Sep 25 1997 - 00:00:00 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US