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 -> Q: INSERT, UPDATE and how to catch rowid

Q: INSERT, UPDATE and how to catch rowid

From: Starous <starek_at_pluto.spsselib.hiedu.cz>
Date: 1997/09/24
Message-ID: <34296D0D.A560B84F@pluto.spsselib.hiedu.cz>#1/1

Please help me to solve this problem.

  I'm inserting a row into table using command

  INSERT INTO my_table
( column list )

  VALUES
( values list );

    After little while I will need to update this new inserted record.   Using index is good, but I'm looking for better performance.

  Is there any chance to catch a rowid of the new inserted record for   later use? ( The same problem coming with UPDATE too )

    Thank you

--
                                          Starous
Received on Wed Sep 24 1997 - 00:00:00 CDT

Original text of this message

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