Re: DBMS_OUTPUT.PUT_LINE question

On Tue, 06 Jun 2000 21:21:45 GMT, hoke_at_gse.harvard.edu (Ken Ho) wrote:

>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?

Ah, now I see that the above and the dbms_output.new_line I mention below works in both SQL Worksheet and in the SQL & DBMS_OUTPUT windows in TOAD (Tool for Oracle Application Developers), but it *doesn't* work in SQL*Plus, which is what you were originally asking about.

In another reply to the original question, Thomas J. Kyte wrote:

there are limits to dbms_output. 2 of them are - no blank lines
- no leading blanks.

Can someone comment on why these limitations are apparently present in SQL*Plus, but not in SQL Worksheet or in TOAD's SQL & DBMS_OUTPUT windows?

>>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 Wed Jun 07 2000 - 00:00:00 CDT