Home » SQL & PL/SQL » SQL & PL/SQL » Null value maintenance
Null value maintenance [message #35610] Mon, 01 October 2001 06:19 Go to next message
kriser
Messages: 11
Registered: October 2001
Junior Member
Does anyone have an efficient strategy for handling null values in a reporting database? The designer of the database wants to have zeros inserted into any column that does not have a transaction for a given month.

Example1 (New record is created in month 10 - Previous 9 months need to be updated with zeros)

Example2 (A record does not have a transaction for current month - Column needs to be updated with zero value.)

----------------------------------------------------------------------
Re: Null value maintenance [message #35615 is a reply to message #35610] Mon, 01 October 2001 10:23 Go to previous messageGo to next message
ASR
Messages: 1
Registered: October 2001
Junior Member
I think writng trigger should resolve your problem.

Thanks,
Aluri

----------------------------------------------------------------------
Re: Null value maintenance [message #35623 is a reply to message #35610] Tue, 02 October 2001 04:47 Go to previous message
jim
Messages: 74
Registered: July 2000
Member
I would look at modifying the table to set the columns as not null with defaults of zero.

----------------------------------------------------------------------
Previous Topic: Re: HOW to cpnvert varchar2 to NUMBER?
Next Topic: Re: How to get the 'quota' of a user on certain tablespace?
Goto Forum:
  


Current Time: Sat May 25 08:34:57 CDT 2024