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: Slow Update!!

Re: Slow Update!!

From: <fitzjarrell_at_cox.net>
Date: 5 Jul 2006 09:46:04 -0700
Message-ID: <1152117964.174927.225000@v61g2000cwv.googlegroups.com>

jsfromynr wrote:
> Hello All,
>
> I am trying to update a table where based on some condition I am
> creating a group. For that matter I used the Minimum rowid of the group
> in the column minrowid.
>
> Update TableX X set minrowid =
> (
> Select min(rowid) from TableX Y where
> X.Name=Y.Name
> And X.City=Y.City
> )
>
> This table contains two or more rows for same combination of Name and
> City , so where clause is of no use.
>
> I was thiking of using a intermediate table as
>
> create table XYZ as
> Select min(rowid) minrowid,Name,City from TableX group by Name,City
>
>
> Then
> Update TableX X set minowid=(Select minrowid from XYZ Y where
> X.Name=Y.Name
> And X.City=Y.City
> )
>
> Will this Help!!!
>
> As I am running the statement in Procedure , ORacle does not allow me
> to create table
>
> Any Help is appreciated
>
> With warm regards
> Jatinder Singh

Why are you storing ROWID data in a table? Reloading the source table invalidates the values in your dependent table. I don't understand the purpose of this exercise.

David Fitzjarrell Received on Wed Jul 05 2006 - 11:46:04 CDT

Original text of this message

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