| 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 any procedures.
..................Content has been hidden....................
You can't read the all page of ebook, please click
here login for view all page.