Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Re: Slow Update!!
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
![]() |
![]() |