Re: dbms_output.put_line

In article <64r4e6$ir0$1_at_wyrm.its.uow.edu.au>, Phil Herring <revdoc_at_uow.edu.au> writes:
>Seriously, the leading spaces will be stripped off. You probably don't want
>this to happen. I usually precede output like this with some non-whitespace
>character to stop this from happening. For example:
>
>DBMS_OUTPUT.PUT_LINE('* col1 col2');
>DBMS_OUTPUT.PUT_LINE('* ' || lpad(to_char(col1),4)||lpad(to_char(col2),10));
>

Why not using

  DBMS_OUTPUT.PUT_LINE(CHR(8) || lpad(to_char(col1),4)...etc

With CHR(8) you don't get an extra character and you will see all your leading spaces.

De mazzel,
Danny Received on Tue Nov 18 1997 - 00:00:00 CST