|
How to update data table column values from a certain result value, Use the value of table A to update the value of the cloumn_name column of the tble_name table table A ： tble_name cloumn_name UUID_name ID_value upnew_value contacts city ID 1 kitchener contacts state ID 2 tx contacts fax ID 2 5105551309 Need to be converted to a dynamic cursor to fetch the value exp: update a.table_name set a.clounm_nname=a.n_value where a.uuid_name=a.id_value update contacts set city=kitchener where id=1 thanks |
begin
declare ntable_name char(60);
declare ncloumn_name char(60);
declare nuuid_name char(60);
declare nID_value integer;
declare nupnew_value char(60);
declare @sqlstr long varchar;
declare err_notfound exception for sqlstate value '02000';
declare update_t dynamic scroll cursor for
select * from A for update;
open update_t;
uploop: loop
fetch next update_t into ntable_name,ncloumn_name,nuuid_name,nID_value,nupnew_value for update;
if sqlstate = err_notfound then
leave uploop
else
set @sqlstr = 'UPDATE ' || ntable_name || ' '
|| 'set ' || ncloumn_name || ' = ' || ''''|| nupnew_value || ''''|| ' where '
|| nuuid_name || ' = ' || nID_value;
execute immediate with result set on @sqlstr
-- prepare updatetable from @sqlstr ;
-- execute updatetable ;
--DEALLOCATE PREPARE updatetable;
--UPDATE table_name SET ncloumn_name = nupnew_value where nuuid_name=nID_value
end if
end loop uploop;
close update_t
end
Hm? I just don't understand... But if you have answered your question, than it's fine for me...
(18 Feb '20, 10:32)
Volker Barth
Replies hidden
|
I don't understand what your actual question is...
dint understood the question at all.