Number of Carrier trucks based on Order value
For a given Carrrier , on any given day we do not want to send more than one million dollar worth of Order value on a single truck.Whenever the Order value for a given day exceeds one million dollar for a carrier truck, we need to use a second Carrier truck.One Carrier truck should not carry more than one million dollar value. How do we accomplish this in oracle.
Thanks