Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: update statement PL/SQL
pobox002_at_bebub.com wrote:
> DA Morgan wrote:
>
>>pobox..._at_bebub.com wrote: >> >>>Reallybig wrote: >>> >>>>I'm a newbie here. I try to update data from 1 table from another >>>>table. So I used cursor to update my employee table on Total_sale >>>>column = amount column on Sales Table where employee.empid = >>>>sales.empid. The problem is for 700,000, it took 2 hours to update. >>>>That's too long. Any Ideas or some sample codes would really >> >>>helpful. >> >>>>Thanks >> >>>Hopefully this is some kind of data warehouse, in which case you
>>>look into materialized views. >> >>Could you please explain how without any DDL or DML you can give this >>advice? >> >>And then explain how this advice has anything to do with updating >>a table with 700,000 rows? It seems to me a materialized view is >>completely irrelevant but maybe I'm missing something.
How did you figure all of this out from the OP's original post?
Here is what the OP wrote:
"I try to update data from 1 table from another table."
All the materialized views on the planet will not update a table.
-- Daniel A. Morgan University of Washington damorgan_at_x.washington.edu (replace 'x' with 'u' to respond)Received on Thu Apr 28 2005 - 11:29:50 CDT