Orders for a given day exceeding one million dollar to go onto a separate truck

Hi,

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