a table with a pk and status column which is having values as 'Y','N','NULL'

Query:

get the count of records with status column as 'Y', if this count exceeds 1% of total count of records then dont delete , else delete the records in the table.

i tried like this

     Declare   
      v_count Number;   
      v_count1 Number;   
     BEGIN   
     v_count := select count(*) from temp;

     v_count1 := select count(*) from temp where status = 'Y' ;

v_count := v_count + ((0.1) * (v_count))

if (v_count1 > v_count)
{
    insert into  temp1 values(pk,status)
}   
else
{     
    Delete from temp ;
}
    END;