Re: DBMS_OUTPUT.PUT_LINE question

On Tue, 06 Jun 2000 17:43:38 GMT, Turdcutter_at_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
Received on Tue Jun 06 2000 - 00:00:00 CDT