Subject: Re: Fixed format output
References: <5f486h$> (David Turner) writes:

>	Does anyone know how to format the output for the 
>dbms_output.put_line. Or possibly another function that will do fixed format

>					Thanks David Turner

You can use the RPAD and SUBSTR functions to make a fixed format output.
For example, to ensure that a column XXX is 30 characters:


The SUBSTR(XXX,1,30) will output up to the first 30 characters.
The RPAD(...,30) will append spaces to make the string 30

-Ari Kaplan
Independent Oracle DBA Consultant

<-> Visit my Web Page:                          <->
<->             email:                    <->

Back to Ari Kaplan's Home Page Kaplan's Home Page