将查询出来的结果是以逗号分隔的数据替换成可以写在in条件后面的格式

declare 
  v_sql varchar(4000) ;
  BEGIN
 -- v_sql :='修改的内容';
    SELECT c.value into v_sql FROM  configurations  c  where c.code='needStorgeMaterialTypes';
    update simpletypes s1 set s1.name=(select ''''||replace(v_sql,',',''',''')||'''' from dual)
    where s1.code='111111' and s1.classtype='MaterialType';
  END;