Applying It

Independent Exercise 1:

  • Build a simple SQL query, logged in as SCOTT, using the EMP and DEPT tables.
    • Display the results.
    • Model the SQL relationships.
    • Show an explain plan.
    • Change some salaries one row at a time.

Independent Exercise 2:

  • Add a new user.
  • Grant this new user the same privileges as SCOTT.

Independent Exercise 3:

  • Build a POST-INSERT trigger on the EMP table.
    • Have it make sure the DEPTNO code is in the DEPT table.
    • Have it loop 10 times, updating a variable by 10 with each loop.
  • Set a break point just inside the loop.
    • Check the value of the variable with each loop.

Independent Exercise 4:

  • Using the Schema Browser, see if EMP has ...

Get Oracle9i™ Development by Example now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.