select count(*) from SCOTT.MYTABLE tb
where not exists 
(select * from SCOTT.MYTABLE tb ,SCOTT.MYTABLE tb_in where
tb_in.rowid= tb.rowid
and
 (col1= 'Status' and col2 = 'property'));