Tables should be given a meaningful name that describes the purpose of the table. All table names should be plural and where the table name contains more than one word only the last should be plural.

Insert Employee: Write a PL/SQL block that inserts a new employee into the employees table. Update Employee Salary: Create a PL/SQL block that increases an employee's salary by 10% where the emp_id is ...

The Oracle Provider for OLEDB has some nice methods for retrieving an array from a PL/SQL procedure call and making it appear to be a Recordset object. It's a bit trickier to go in the other ...