A Selection of PL/SQL References

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

Last modified: Wednesday, February 19, 2025

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
  
  
• https://docs.oracle.com/cd/A97630_01/appdev.920/a96624/toc.htm - Oracle's "PL/SQL User's Guide and Reference"
  • https://docs.oracle.com/cd/A97630_01/appdev.920/a96624/01_oview.htm - direct link to its Section 1 - "Overview of PL/SQL"
  • https://docs.oracle.com/cd/B13789_01/appdev.101/b10807/02_funds.htm - direct link to its Section 2 - "Fundamentals of the PL/SQL Language"
  • https://docs.oracle.com/cd/A97630_01/appdev.920/a96624/03_types.htm - direct link to its Section 3 - "PL/SQL Datatypes"
    
    
  • https://docs.oracle.com/cd/A97630_01/appdev.920/a96624/01_oview.htm#740 - direct link to its "Cursors" subsection in Section 1 - "Overview of Pl/SQL"
  
  
• https://docs.oracle.com/en/database/oracle/oracle-database/19/lnpls/plsql-triggers.html - Oracle documentation on PL/SQL Triggers
  
  
• https://www.oracle.com/database/technologies/appdev/plsql.html - 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!
  
  
• https://docs.oracle.com/en/database/oracle/oracle-database/23/lnpls/predefined-exceptions.html - Table 12-3 - PL/SQL Predefined Exceptions

Back to Course Home Page