triggers Please solve this one urgent

Jun 22 2012 6:14 AM

if i create table
dept

contain fields

deptno,deptname,depthead

if i insert the deptname compulsary for every timeinsert how can i check that condition in trigger

please write the trigger for that problem....if any body help me it is very urgent