Re: Is it Possible to Update a table with a fetched cursor record?

<gcoyle_at_cbs.webramp.net> wrote in message news:37e6a14f.25260210_at_news.supernews.com...
> If you fetch a record like firstname,last name,number in a cusror from
> table1 and want to update Table2
>
> what is the proper plsql syntax to do something like this?
> with cursor do
> update table2
> set table2.firstname = cusror.firstname
> set table2.lastname = cusror.lastname
> set table2.number = cusror.number
> end;
>
> Thanks for you help
> GC

It's trivial and can be done using SQL. But, what is the relation between your table1 and table2? Describe your requirement more clearly. Received on Fri Sep 24 1999 - 15:13:08 CDT