1 BEGIN  
2   UPDATE AAA_TEST SET VALUE=‘AAAA‘ WHERE ID=1;
3    IF SQL%NOTFOUND THEN
4    INSERT INTO  AAA_TEST(ID,VALUE)VALUES(1,‘AAAA‘);
5    END IF;
6 END;