Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: How to embed a newline in a PLSQL VARCHAR2

Re: How to embed a newline in a PLSQL VARCHAR2

From: Tina Tran <tinat_at_sonica.com>
Date: 1997/10/03
Message-ID: <01bcd026$0078e970$2aaeb6cc@dino>#1/1

try:
v_string := 'This string should split' || chr(10) || 'into two lines';

Edward Baggott <eabaggot_at_hiwaay.net> wrote in article <ze7wo5mz8GA.139_at_news2.ingr.com>...
> I want to do something like
>
> v_string VARCHAR2(100);
>
> v_string := 'This string should split \ninto two lines';
> DBMS_OUTPUT.PUT_LINE(v_string);
>
>
> This string should be split
> into two lines
>
>
> How to do?
>
> Yrs,
> Ed
>
>
>
>
  Received on Fri Oct 03 1997 - 00:00:00 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US