Re: I need help with SQL

From: Jerry Gitomer <jgitomer_at_erols.com>
Date: Thu, 19 Oct 2000 03:54:01 GMT
Message-ID: <20001019.3540100@mis.configured.host>

Try

SET NUMWIDTH n where n is the maximum number of digits in your total.

You can also use the SQL*Plus Column command:

COLUMN total balance FORMAT '999,999,999,999.99'

>>>>>>>>>>>>>>>>>> Original Message <<<<<<<<<<<<<<<<<<

On 10/18/00, 8:23:08 PM, "Brian Vuong" <brian-vuong_at_usa.net> wrote regarding I need help with SQL:

> I have the following query

> spool list.lst
> select account(*), sum(balance)
> from table1
> ;
> spool off;

> --The total balance is so large that it gives me only '###########'
instead
> of digits such as '74857843389349'. Is there anyway I can fix this?
Any
> help is appreciated.
> I use SQLPLUS.

> Thanks,

> Brian Vuong
Received on Wed Oct 18 2000 - 22:54:01 CDT