select avg(unitprice) , max(unitprice) , min(unitprice) into v_avg_price , v_max_price , v_min_price from magazine where genre = mgenre;
user13631888 wrote:You are selecting from table dual which does not have column pets. I am assuming pets is mgenre value, right? Then you need to use it as string literal - enclose it in quotes
select pricing(pets) from dual;
select pricing('pets') from dual;SY.