Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Is it Possible to Update a table with a fetched cursor record?

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

From: <gcoyle_at_cbs.webramp.net>
Date: Mon, 20 Sep 1999 21:11:15 GMT
Message-ID: <37e6a14f.25260210@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 Received on Mon Sep 20 1999 - 16:11:15 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US