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

Home -> Community -> Usenet -> c.d.o.tools -> Re: a string with carrige returns

Re: a string with carrige returns

From: Jim Lyons <jlyons_at_weblyons.com>
Date: 22 Jun 2001 09:11:39 -0700
Message-ID: <e67857c9.0106220811.44909f6@posting.google.com> 






"Andrei Romazanov" <romazanov.andrei_at_gfos.de> wrote in message news:<9gvmcc$b9gcv$1_at_ID-70985.news.dfncis.de>...


> Hi,

> 

>  how can I arrange a string in a PL/SQL-function , which contains carrige

> returns?




You can use the CHR function.  If I insert a string like:
'line 1' || chr(10) || 'line 2' into a table and then display that field,
the output is:



line 1


line 2



Is this what you mean?



Jim Lyons
Received on Fri Jun 22 2001 - 11:11:39 CDT












Original text of this message













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