help for creating trigger to control the insert according to salary>1000!!!!

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • abhu50
    New Member
    • Jun 2007
    • 20

    help for creating trigger to control the insert according to salary>1000!!!!

    hiiiiiiii
    i wan to create trigger for table emp0
    attribute are:-
    eno ename sal dno

    now i want to contro insertion on emp0 by using trigger that will allow only those record having salary greater than 1000 otherwise will not insert record.
    plzzzzzzzz help me
  • debasisdas
    Recognized Expert Expert
    • Dec 2006
    • 8119

    #2
    create a trigger on insert event

    check for :new.sal >1000;


    try with this logic from your side.

    if unable please post back with your code, i am always here to help you.

    Comment

    Working...