Support Materials

• SQLPlus Commands
  
• A very simple intro to Oracle SQL
  
• Oracle SQL Reference from oracle.com
  
  
• Introductory Material on Sets, Relations and Functions can be found here.
  
  
• DB I at other universities
  • Stanford
  • Wisconsin
  
  
• Example Views can be found here
  
• Example Stored Procedures and Triggers can be found here

• Oracle Documentation is available here
• MySQL Documentation is available here
  
  
  Introduction to JDBC with Oracle from Stanford can be found here
  Reference on calling procedures/functions using java.sql.CallableStatement: http://java.sun.com/javase/6/docs/api/java/sql/CallableStatement.html
  
  
• Embedded SQL
  • Extra reference on using SQL with C on Oracle can be found here
    
    
  • Sample code for using SQL with Java (here)