From: hoke@gse.harvard.edu (Ken Ho)
Subject: Re: DBMS_OUTPUT.PUT_LINE  question
Date: 2000/06/06
Message-ID: <393d6a99.28278948@news.harvard.edu>#1/1
References: <393e373d.153280329@news.erols.com>
X-Complaints-To: usenet@harvard.edu
X-Trace: plato.harvard.edu 960326535 28980 128.103.181.54 (6 Jun 2000 21:22:15 GMT)
Organization: Harvard University Network Operations Center
NNTP-Posting-Date: 6 Jun 2000 21:22:15 GMT
Newsgroups: comp.databases.oracle.misc


On Tue, 06 Jun 2000 17:43:38 GMT, Turdcutter@eremove.edu (Turdcutter)
wrote:

>How do you get this function to insert leading spaces?
>
>DBMS_OUTPUT.PUT_LINE('     '|| var1)

That works for me.  What type of variable is var1, and what is its
value?

>gives no leading spaces   
>
>
>?????
>
>
>also,,,
>
>how could you do a carriage return with this function
>	DBMS_OUTPUT.PUT_LINE('') < ----   doesn't seen to work

I imagine what you want is:

dbms_output.new_line;

although if you don't mind an extra space being output, you could of
course use

dbms_output.put_line(' ');      (a space is between the single quotes)

>
>thank you