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

Home -> Community -> Usenet -> c.d.o.tools -> I need help with SQL

I need help with SQL

From: Brian Vuong <brian-vuong_at_usa.net>
Date: Wed, 18 Oct 2000 17:23:08 -0700
Message-ID: <susfs7tgs5d03a@corp.supernews.com> 






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 - 19:23:08 CDT












Original text of this message













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