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

Home -> Community -> Usenet -> c.d.o.misc -> Re: format a number in a cursor?

Re: format a number in a cursor?

From: $ Robert $ <drsql_at_tir.com>
Date: 1997/06/18
Message-ID: <33A873C4.5226@tir.com>#1/1

Richard Burton wrote:
>
> How do I format a number column when retriving the data from a cursor
> in PL/SQL?
>
> Thanks,
> rburton_at_rohms.com

to_char(column,'format mask')

for example

select to_char(&inputvalue,'999,999,990.000') from dual; Received on Wed Jun 18 1997 - 00:00:00 CDT

Original text of this message

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