A cursor is a pointer to this context area. PL/SQL controls the context area through a cursor. A cursor holds the rows (one or more) returned by a SQL statement. The set of rows the cursor holds is ...
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; ...
Results that may be inaccessible to you are currently showing.
Hide inaccessible results
Feedback