dbms_output语句中的单引号? [英] Single quote in dbms_output statement?
本文介绍了dbms_output语句中的单引号?的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
我需要在dbms_output语句中包含单引号.我已经尝试过了:
I need to include single quotes in dbms_output statement. I've tried this:
dbms_output.put_line('\''first_name||'\'');
这里的名字是 variable
;我需要在单引号中显示它.
Here first_name is variable
; I need to display this inside single quotes.
推荐答案
您可以通过加倍逃脱:
dbms_output.put_line('''' || first_name || '''');
或使用 q报价机制:
dbms_output.put_line(q'[']'||first_name||q'[']');
例如:
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.
这篇关于dbms_output语句中的单引号?的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文