SQL & PL/SQL

Hi,

Is it possible to do a conditional insert? e.g.

IF :P2_NAME != (SELECT name from hk.appname where name = :P2_NAME) then
INSERT....
END IF;

So if the value of :P2_NAME doesn't exist within the table then it will be inserted...its to be an addition to a currently existing APEX process (checks that field values aren't null then enters a record into a different table than hk.appname).

Thanks for any help.

Mike