Problems with views and SUM

From: Frederic Rivalland <frivalla_at_terre.univ-lr.fr>
Date: 1996/07/04
Message-ID: <4rfusd$n8p_at_hpuniv.univ-lr.fr>#1/1


Hi

	I ve got a problem with a SELET from a VIEW.
	I ve create a view like :

	create or replace view CUMUL_DEB ( exer,dates,debit) as
	select j.jou_exer,j.jou_date, sum(e.ecr_mont) 
	from journal j , ecriture e
	where j.jou_ordre = e.ecr_ordre
	and j.jou_type <> 'A'
	and ecr_sens = 'D'
	group by j.jou_exer,j.jou_date;

	it s ok ,i ve got rigth result :
	
	SQL> desc CUMUL_DEB
	 Name                            Null?    Type
	 ------------------------------- -------- ----
	 EXER                                     VARCHAR2(2)
	 DATES                                    DATE
	 DEBIT                                    NUMBER


	SQL> select * from CUMUL_DEB;

	EX DATES          DEBIT
	-- --------- ----------
	95 02-JAN-95    2071.07
	95 03-JAN-95 31617635.6
	95 04-JAN-95   11859125
	95 05-JAN-95   18489.99
	...

	My Problem is that when i do a sum with the field DEBIT i lost  
informations (decimal) :
	SQL> select exer, sum(debit) 
 	  from CUMUL_DEB
	  where exer = 96
	  and dates < sysdate
	  group by exer;

	EX SUM(DEBIT)
	-- ----------
	96  291787806
	
	I will try 291787806.XX

I am looking for some help, thanks.

FRED.

--
___________________________________________________________________
Frederic RIVALLAND
Centre de Ressources Informatiques
Universite de La Rochelle
Received on Thu Jul 04 1996 - 00:00:00 CEST

Original text of this message