Support Materials

• SQLPlus Commands
  
• A very simple intro to Oracle SQL
  
• Oracle SQL Reference from oracle.com
  
  
• SimpleDB Database Management System [Link]
  
• 
  
• 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
  
  Reference on HTML Forms
  http://www.w3.org/TR/REC-html40/interact/forms.html
  http://www.w3schools.com/html/html_forms.asp
  
  Handout on Perl/CGI, and how to use Perl DBI with Oracle/mySQLps pdf
  Code for the above can be found at: http://www.wpi.edu/~mmani/perlSamples
  
  Simple tutorial on Perl: http://www.tizag.com/perlT/index.php
  Extra Reference on Perl DBI: http://search.cpan.org/~timb/DBI/DBI.pm
  Reference on DBD::Oracle, including how to call Oracle PL/SQL procedures/functions from Perl: http://cpan.uwinnipeg.ca/htdocs/DBD-Oracle/DBD/Oracle.html
  
  Simple user authentication mechanisms using Perl and examples can be found here. ps pdf
  
  Handout on JDBC ps pdf
  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
  
  Handout on servlets ps pdf
  Extra Reference for Servlets can be found here or here

  If you are using servlets, you might bundle up your code as a Web ARchive (WAR). Test your WAR before submitting it. Documentation on how to build your WAR file is available here
  
  

• Embedded SQL
  • More sample code on Pro*C ps pdf
    
    
  • Extra reference on using SQL with C on Oracle can be found here
    
    
  • Sample code for using SQL with Java (SQLJ): ps pdf
  
  
• Some sample pieces of code for building applications can be found here