for j in 3..14 loop v_sql:=' update tab_1 set f:x=1) where fd=''1'' and user_id=:x'; execute immediate v_sql using j,j,p_user_id,p_user_id; end loop;报错误 ORA-00927: 缺少等號求指导,谢谢!
' update tab_1 set f:x=1) where fd=''1'' and user_id=:x' 改为 'update tab_1 set x=1 where fd='1' and user_id=x'
for j in 3..14 loop v_sql:=' update tab_1 set f:x=1 where fd=''1'' and user_id=:x'; execute immediate v_sql using j,p_user_id; end loop;谢谢,:x是占位符,这样写有问题吗?
for j in 3..14 loop v_sql:=' update tab_1 set f:x=1 where fd=''1'' and user_id=:x'; execute immediate v_sql using j,p_user_id; end loop; 执行的时候是 set f:x=1这个占位符的解析,出现问题,缺少等号,user_id的解析没问题 请问 要怎么修改?谢谢
'update tab_1 set x=1 where fd='1' and user_id=x'
for j in 3..14 loop
v_sql:=' update tab_1 set f:x=1 where fd=''1'' and user_id=:x';
execute immediate v_sql using j,p_user_id;
end loop;谢谢,:x是占位符,这样写有问题吗?
v_sql:=' update tab_1 set f:x=1 where fd=''1'' and user_id=:x';
execute immediate v_sql using j,p_user_id;
end loop; 执行的时候是 set f:x=1这个占位符的解析,出现问题,缺少等号,user_id的解析没问题
请问 要怎么修改?谢谢