Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: dbms_output.put_line

Re: dbms_output.put_line

From: <seci_at_ludens.elte.hu>
Date: 1997/11/19
Message-ID: <1997Nov19.083417.45358@ludens>#1/1

hello,
In article <3470B1B8.3C3D_at_tietogroup.com>, Maija-Leena Kangasmäki <maija-leena.kangasmaki_at_tietogroup.com> writes:
> I want to display some numbers with dbms_output.put_line but I don't
> know how to show them nicely in columns like this:
>
> col1 col2
> 1 100
> 10 20
> 100 1
> 200 300

try:

        dbms_output.put_line( TO_CHAR(1,'99999'), TO_CHAR(100,5)); and so on

>
> Regards,
>
> Maija-Leena Kangasmäki
>
> _______________________________________
> Maija-Leena Kangasmäki
> TT-Valtionpalvelut / TT Government Service
> maija-leena.kangasmaki_at_tietogroup.com

HTH
        peter Received on Wed Nov 19 1997 - 00:00:00 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US