Click here to Skip to main content
16,016,605 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
hi, guy and anybody help me to create a trigger.

example I have data:

ITEM.......QTY.......DATE
ABC........100......1-jan-2012
ABC........150......15-jan-2012

on 25 jan 2012, ABC sold out 120, so i want data above remain like this:

ITEM.......QTY.......DATE
ABC........0.........1-Jan-2012
ABC........30........15-Jan-2012

I'm new for oracle, please help me guys,

Thanks in advance.
Sorry for my bad English.
Posted

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900