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: Using DBMS_OUTPUT to output columns?

Re: Using DBMS_OUTPUT to output columns?

From: phersh <philhershNOphSPAM_at_hotmail.com.invalid>
Date: 2000/07/18
Message-ID: <101190f8.5d7f9d9b@usw-ex0105-037.remarq.com>#1/1

Hi Joe,

Thanks for your response. This will make all the fields the same length, but does anyone know the way to tell the receiving client that discrete fields are being returned.

Thanks,
Phil Hersh

Joe Maloney <mpir_at_compuserve.com> wrote:
> printvar := rpad(cursor.field1,32,32)||rpad
 (cursor.field2,32,32)
>||.......
> dbms_output.putline(printvar);


Got questions? Get answers over the phone at Keen.com. Up to 100 minutes free!
http://www.keen.com Received on Tue Jul 18 2000 - 00:00:00 CDT

Original text of this message

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