DECLARE
i int;
BEGIN
select count(1)
into i
from AppTree
where AddressID= 468401
and ClassID = 'A01';
IF i=0 THEN
insert into AppTree(AddressID,ClassID)
Values (468401,'A01');
END IF;
END;
i int;
BEGIN
select count(1)
into i
from AppTree
where AddressID= 468401
and ClassID = 'A01';
IF i=0 THEN
insert into AppTree(AddressID,ClassID)
Values (468401,'A01');
END IF;
END;
Values (468401,'A01')
Where not Exists
(
Select AddressID
From AppTree Where
AddressID = 468401 And ClassID = 'A01'
)
----> No such sql syntax in oracle !
Another way is you can check the NO_DATA_FOUND exception .