cursor c_supplier(no number) is select p.pid,p.pname,c.qty,p.unit_rate,(c.qty*p.unit_rate) "Total Price" from parts p,catalog c,supplier s where p.pid=c.pid and s.sid=c.sid and s.sid = no; ...