Re: I need help with SQL

From: girlgeek <girlgeek_at_wt.net>
Date: Sun, 22 Oct 2000 02:50:34 -0700
Message-ID: <39F2B869.B397B430@wt.net>

Brian,
Try either
set long
or

COLUMN balance FORMAT 99999999999999999999999999999999;

These are sql+ commands not SQL ones.
hth,
Claudia

Brian Vuong wrote:

> 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 Sun Oct 22 2000 - 04:50:34 CDT