User Profile

Collapse

Profile Sidebar

Collapse
sbldragon
sbldragon
Last Activity: Mar 26 '12, 05:46 PM
Joined: Mar 25 '12
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts
  • sbldragon
    started a topic how to check item sold ? date
    in Oracle

    how to check item sold ? date

    hi, guy can anybody help me please 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...
    See more | Go to post
    • sbldragon
      replied to triggers to monitor stock options backdating
      in Oracle
      i like ur post. this example help me to improve my trigger :) i'm new in oracle
      See more | Go to post

        Leave a comment:

      No activity results to display
      Show More
      Working...