By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
446,213 Members | 1,117 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 446,213 IT Pros & Developers. It's quick & easy.

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

P: 20
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
Jun 11 '07 #1
Share this Question
Share on Google+
1 Reply

Expert 5K+
P: 8,127
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.
Jun 11 '07 #2

Post your reply

Sign in to post your reply or Sign up for a free account.