oracle - Oracle中如何输入换行符？

Question

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.';

<小时/>

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

Answer 1

Chr(Number)应该适合你。

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

记住不同的平台需要不同的换行符:

• CHR(10) => LF，换行 (unix)
• CHR(13) => CR，回车(Windows，与 LF 一起)