Create a trigger

Hi all.I am required to create a trigger on an existing table (say x) wherein we have attribute called as level (with accepted values as low,medium and high). Whenever a record is inserted into an existing table (x) with 'level' as 'high',the entire record should be copied to the new table (say y). Is this possible to accomplish using triggers ?

See original post by siddharth007