oracle 更新语句使用变量名代表列名

declare

      i_name varchar2(20);

     s varchar2(2000);

 

begin

     i_name := 'price';

     s :='update items set '||i_name||'=8.99 ' || 'where item_name=''Snow bee3''';

     execute immediate s;

     commit;

     exception when others then

                    dbms_output.put_line(to_char(SQLCODE) || ' - ' || SQLERRM);

end;