Re: DBMS_OUTPUT.PUT_LINE question

As far as leading spaces, format your var1 accordingly (char(20) or whatever to give you enough leading spaces. For blank lines use dbms_output.put_line(chr(13));

You can also look into utf_file if you ever need to output over 1000000 bytes. You can get to 1000000 bytes by dbms_output.enable(1000000);

Hope this is helpful

In article <393e373d.153280329_at_news.erols.com>,   Turdcutter_at_eremove.edu (Turdcutter) wrote:
> How do you get this function to insert leading spaces?
>
> DBMS_OUTPUT.PUT_LINE(' '|| var1)
>
> gives no leading spaces
>
> ?????
>
> also,,,
>
> how could you do a carriage return with this function
> DBMS_OUTPUT.PUT_LINE('') < ---- doesn't seen to work
>
> thank you
>

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Wed Jun 07 2000 - 00:00:00 CDT