17,377
社区成员
发帖
与我相关
我的任务
分享
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>
/--try:
select to_number('0')+8 from dual;