Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.tools -> Re: How to update a table from another table?
"cschang" <cschang_at_maxinter.net> wrote in message
news:39C39587.418_at_maxinter.net...
> I like to know is there a way to update mutliple rows of a table from
> multirows of another table? Thanks
>
> C. Chang
Sure, just use the update command with a subquery.
Regards,
Sybrand Bakker, Oracle DBA Received on Sat Sep 16 2000 - 12:33:28 CDT