put carriage return into VARCHAR2 using PL/SQL
From: Ming-Ding Tsao <mtsao_at_cas.org>
Date: 1996/09/06
Message-ID: <x6eloeng4ue.fsf_at_mdt26awm.i-have-a-misconfigured-system-so-shoot-me>#1/1
Date: 1996/09/06
Message-ID: <x6eloeng4ue.fsf_at_mdt26awm.i-have-a-misconfigured-system-so-shoot-me>#1/1
Question: In R7.3.2 using PL/SQL how to put the carriage return(0x0d
or 0x0a) into a string ?
For example:
achar VARCHAR2(16);
achar := 'test' || ' ' || 'line' || ' ';
- how to put a line feed to replace the last ' ' above.
In PL/SQL documentation it states character literals include all the
printable characters in the PL/SQL character sets, and the character
set include "tabs, spaces, and carriage returns". I noticed that
functions are used to produce a line feed such as dbms_output.newline or it
is done implicitly in side a function such as put_line().
Thanks, Ming Tsao
--
Received on Fri Sep 06 1996 - 00:00:00 CEST