Re: DBMS_OUTPUT.PUT_LINE question

Turdcutter <Turdcutter_at_eremove.edu> wrote:
> How do you get this function to insert leading spaces?
> DBMS_OUTPUT.PUT_LINE(' '|| var1)
> gives no leading spaces
> ?????

This is is know 'feature' of dbms_output.

I gave up trying any sort of formatted output with dbms_output & resorted to inserting the lines in a table, then reading it out at then end.

This kills two birds with one stone:

1. I can see the output as the script runs,
2. I can control the formatting exactly.

> thank you

Your welcome...

-- 
 _--_|\  John Verhoeven           Unix / Database Administrator Westrail
/      \       johnhv_at_iinet.net.au / jverhoeven_at_westrail.wa.gov.au
*_.--._/
      v   "Smile! things could be worse... So I did... and they were..."