Re: PL/SQL

Insert or update using a %ROWTYPE is a known requirement. Not currently available though.

John

On 28 Sep 2001 11:42:49 -0700, gloriaz_ca_at_yahoo.com (Gloria Zhao) wrote:

>Hi there,
>
> I would like to update an entire row of a record in a table by
>using %rowtype. In this case I don't have to mention the individual
>column's names for the row. Is there any way that I can do it in
>Oracle, like assigning a record in table1 to a record in table2 when
>they have the same key fields? I would appreciate it if you could
>provide any advise.
>
>Thanks a lot.
>
>Gloria

--
Got an Oracle database question?
Try the search engine for the database docs at:
http://tahiti.oracle.com/