Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: format a number in a cursor?
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