Programming with cursors

1
Programming with cursors

• In PL/SQL

2
Cursors for update

• Look at the examples in the lecture notes.
• Write a program that Accepts a supplier name and
  a percentage amount.
• Find the supplier id for the supplier.
• Using a cursor, for each item of stock supplied
  by the supplier,
• display the current stock code, description,
  cost price and unit cost price.
• Increase the unit cost by the percentage amount
  and
• display the new cost.