日期:2014-05-17 浏览次数:21172 次
OPER@TL> 1 declare 2 str_sql varchar2(100); 3 m varchar2(30); 4 begin 5 m:='=''0'''; 6 str_sql:='insert into test values(:1)'; 7 execute immediate str_sql using m; 8 end; 9 / PL/SQL procedure successfully completed. OPER@TL>select * from test; AAA ------------------------------ ='0' OPER@TL>
------解决方案--------------------
告诉你一个方法:
insert into tablename values('&a');
执行后在弹出的对话框里输入值,试试你就明白要怎么写了.