Re: DBMS_OUTPUT

From: Frank Hubeny <fhubeny_at_ntsource.com>
Date: 1997/12/03
Message-ID: <34862F15.D712773A@ntsource.com>#1/1

This is a multi-part message in MIME format. --------------547105CDFAB13A6224E63A04
Content-Type: multipart/alternative; boundary="------------C1CF3B1777B597A635829422"

--------------C1CF3B1777B597A635829422
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit

I was able to get a blank line with the following:

SQL> execute dbms_output.put_line('this' || chr(10) || chr(10) || 'is it');
this

is it

PL/SQL procedure successfully completed.

Naren Chintala wrote:

> Hi,
>
> I print the values from a table to stdout using DBMS_OUTPUT.PUT_LINE.
> I need to separate each value with a blank line. I am unable to
> print a blank line using DBMS_OUTPUT.PUT_LINE.
>
> Any ideas.
>
> Thanx
> Naren



--------------C1CF3B1777B597A635829422

Content-Type: text/html; charset=us-ascii Content-Transfer-Encoding: 7bit

<HTML>

I was able to get a blank line with the following:

<TT>SQL> execute dbms_output.put_line('this' || chr(10) || chr(10) ||
'is it');</TT>
 <TT>this</TT><TT></TT>

<TT>is it</TT><TT></TT>

<TT>PL/SQL procedure successfully completed.</TT>
 <TT></TT> 

Naren Chintala wrote:
<BLOCKQUOTE TYPE=CITE>Hi,

I print the values from a table to stdout using DBMS_OUTPUT.PUT_LINE.
 I need to separate each value with a blank line. I am unable to
 print a blank line using DBMS_OUTPUT.PUT_LINE.

Any ideas.

Thanx
 Naren</BLOCKQUOTE>

 </HTML>

--------------C1CF3B1777B597A635829422--

--------------547105CDFAB13A6224E63A04
Content-Type: text/x-vcard; charset=us-ascii; name="vcard.vcf"
Content-Transfer-Encoding: 7bit
Content-Description: Card for Frank Hubeny
Content-Disposition: attachment; filename="vcard.vcf"

begin:          vcard
fn:             Frank Hubeny
n:              Hubeny;Frank
adr:            427 East Liberty Drive;;;Wheaton;IL;60187-5510;USA

email;internet: fhubeny_at_ntsource.com
x-mozilla-cpt: ;0
x-mozilla-html: TRUE

version:        2.1
end:            vcard

--------------547105CDFAB13A6224E63A04-- Received on Wed Dec 03 1997 - 00:00:00 CST