如何在Oracle中输入换行符? [英] How to enter newline character in Oracle?

问题描述

select col1, col2
    into name1, name2
    from table1
    where col1=col;

        m_sub := 'Subject ';
    m_msg := 'Hello '||name||' ,'||/n||/n||'Your order has been placed.';

---

错误(34,33):PLS-00103:预期出现符号"/"时遇到 以下内容:(-+ case mod new空平均计数 当前最大最小先前sql stddev总和方差执行全部合并 时间时间戳记间隔日期管道

Error(34,33): PLS-00103: Encountered the symbol "/" when expecting one of the following: ( - + case mod new null avg count current max min prior sql stddev sum variance execute forall merge time timestamp interval date pipe

推荐答案

Chr(数字)应该适合您.

select 'Hello' || chr(10) ||' world' from dual

请记住不同的平台期望使用不同的换行符:

Remember different platforms expect different new line characters:

• CHR(10)=> LF，换行符(unix)
• CHR(13)=> CR，回车(Windows和LF)

这篇关于如何在Oracle中输入换行符?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！