Re: DBMS_OUTPUT

[Quoted] In article <6ndtuc$jdh$1_at_alexander.INS.CWRU.Edu>, Dennis M. Hancy <dw724_at_cleveland.Freenet.Edu> wrote:
>How does one print a blank line using DBMS_OUTPUT?
>I tried this:
> DBMS_OUTPUT.PUT_LINE(' ');
>but it didn't work. Any ideas? Thanks.
>Dennis Hancy

DBMS_Output seems to wipe out all leading spaces in a line, so I usually write a small procedure to insert a period or something else as the first character if the string I'm trying to print has a leading space. But I've never tried to print a blank line.

This seems to work--but for me it prints two blank lines: print a chr(10), which should be a "line feed" character.   dbms_output.put_line(chr(10));

Trying chr(0) gives me one blank line. But that may be dependent upon what platform your are running on.

Regards,
Steve Cosner
http://members.aol.com/stevec5088 Received on Fri Jul 10 1998 - 17:23:57 CEST