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

Home -> Community -> Usenet -> c.d.o.server -> Re: How to put an end of line character in text string

Re: How to put an end of line character in text string

From: Hans Bos <hans.bos_at_xelion.nl>
Date: 2000/04/07
Message-ID: <8ckr44$9v4$1@porthos.nl.uu.net>#1/1

Hello,

Why not put a new line withing quotes.

The following works in oracle 8i:
SQL> select 'first line
  2 next line' from dual;

'FIRSTLINENEXTLINE'



first line
next line

Greetings,
Hans.

<tim.mcconechy_at_runtime.dk> wrote in message news:8ck7r5$2a8$1_at_nnrp1.deja.com...
> HI!
> How do I put the end of line character at the and of a text string...
> Example:
>
> l output:l output||l separator||l columnValue||!WHAT GOES
> HERE!;
>
> l output is a long variable and I want to
> place multiple lines from here into a LONG field on a table.
>
> All I need to know is how I create the end of line character!
>
> Thanks!

--
Received on Fri Apr 07 2000 - 00:00:00 CDT

Original text of this message

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