A Selection of PL/SQL References

CS 328 - Web-Apps Using Databases
Section 10 - CRN 22226 - MW 3:00-4:20
Spring 2026

Last modified: Wednesday, February 11, 2026

Important Notes:

• Note: if any of these references happen to follow coding or style standards other than the CS 328 coding or style standards, you are still expected to follow the CS 328 coding and style standards for CS 328 course work! 8-)

• CS 328 SQL and PL/SQL Coding Standards so far
  
  
• Prof. Li's CS 325 - SQL Reading Packet 10 that introduces PL/SQL triggers is posted on the course Canvas site, under Modules, section "Course Style and Coding Standards and Language References"
  
  
• Oracle's "PL/SQL User's Guide and Reference"
  • direct link to its Section 1 - "Overview of PL/SQL"
  • direct link to its Section 2 - "Fundamentals of the PL/SQL Language"
  • direct link to its Section 3 - "PL/SQL Datatypes"
    
    
  • direct link to its "Cursors" subsection in Section 1 - "Overview of Pl/SQL"
  
  
• Oracle documentation on PL/SQL Triggers
  
  
• Oracle's "Getting Started With PL/SQL" page, with many links

• Some string- and date- and time-related SQL functions - because these can be called in PL/SQL statements as well!
  
  
• Oracle documentation Table 12-3 - PL/SQL Predefined Exceptions

Back to Course Home Page