Re: When does Update become Delene then Insert, Ora817

From: Tianhua Wu <tianhua.wu_at_mirant.com>
Date: 26 Feb 2002 07:29:31 -0800
Message-ID: <18e503ea.0202260729.794dee4c@posting.google.com>

"Kapal Mo" <kapalmo_at_nospam.hotmail.com> wrote in message news:<dZzc8.16523$X2.186207_at_nnrp1.uunet.ca>...
> What situations should happen for an update be processed by the database as
> a delete then insert?

I have not test this myself, just a thought: For Oracle, If you use IOT, and when you update your primary key, you could end up with a delete and an insert instead of a update. Received on Tue Feb 26 2002 - 09:29:31 CST

This message: [ Message body ]
Next message: paul_at_redfacedrhino: "Re: ora-01516 on alter database rename file"
Previous message: April: "Re: Subquery help with Max !"
In reply to: Kapal Mo: "When does Update become Delene then Insert, Ora817"

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

Original text of this message

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