Re: dbms_output.put_line question

From: Bob <pruder_at_gatorbait.com>
Date: 1997/08/18
Message-ID: <01bcac1a$356e9ce0$100000be@fs>#1/1

9 is ctrl^I (tab) in ASCII code chart.

SQL> execute dbms_output.put_line(chr(9)||'text string');

text string

PL/SQL procedure successfully completed.

-- 
Bob
Gator Bait Software

spam-offAlan Long <TICS28_at_email.mot.com> wrote in article
<TICS28-1808971225570001_at_tics28.sps.mot.com>...


> The line:

> 

>             dbms_output.put_line('     text string');

> 

> produces output which omits the leading blanks. The only solution I have

> found is to include a leading period:

> 

>             dbms_output.put_line('.     text string');

> 

> This seems a bit dumb, uses up one column of output, and looks untidy. Is

 there


> a better way?

> 

> I'm using Oracle 7.1.4 and PL/SQL 2.1.4

> 

> -- 

> Alan Long

> Materials Systems Group

> Motorola, East Kilbride, Scotland

> email tics28@"spam-off"email.mot.com (remove the "spam-off")

>

Received on Mon Aug 18 1997 - 00:00:00 CDT