我需要在 dbms_output 语句中包含单引号。我试过这个:
dbms_output.put_line('\''first_name||'\'');
这里的名字是variable
;我需要在单引号内显示它。
你可以通过加倍逃脱:
dbms_output.put_line('''' || first_name || '''');
或使用q-quote http://www.oracle-developer.net/display.php?id=311机制:
dbms_output.put_line(q'[']'||first_name||q'[']');
eg:
SQL> var b1 varchar2(30)
SQL> exec :b1 := 'this is a test';
PL/SQL procedure successfully completed.
SQL> exec dbms_output.put_line(q'[']'||:b1||q'[']');
'this is a test'
PL/SQL procedure successfully completed.
SQL> exec dbms_output.put_line(''''||:b1||'''');
'this is a test'
PL/SQL procedure successfully completed.
SQL> exec dbms_output.put_line(chr(39)||:b1||chr(39));
'this is a test'
PL/SQL procedure successfully completed.
本文内容由网友自发贡献,版权归原作者所有,本站不承担相应法律责任。如您发现有涉嫌抄袭侵权的内容,请联系:hwhale#tublm.com(使用前将#替换为@)