Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> Is it Possible to Update a table with a fetched cursor record?
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
Thanks for you help
GC
Received on Mon Sep 20 1999 - 16:11:15 CDT
![]() |
![]() |