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.