sqlstr := 'update sfcdata.JSPARAMS set PARAM2 = ''' || Water ||
''', JSMONTH = ''' || CalMon || ''',
' || v_MonthField || '= ''' || MonthTotal ||
''' where DEFINESA = ''' || PaperType || '''
and param2 =''' || v_param2 || ''' and JSMONTH =''' ||
v_jsMonth || '''';
execute immediate sqlstr;
commit;
Oracle 存储过程内执行SQL
最新推荐文章于 2024-04-18 16:08:09 发布