Oracle Materials
CIS 208A Oracle PL/SQL Programming

General information

• iLearning Setup FAQ (2007)
• Oracle Application Express resource page
• Log in to iLearning site instructions
• All of the table in Application Express (APEX)   - Print these out when working on SQL assignments
• Provided database ERDs
  • DJ database
  • Oracle database
  • Global Fast Foods database

PL/SQL reference information

SQL reference information

• Creating a Table handout
• Updating and Deleting Data
• Null General Functions
• Null Value Notes
• Key Functions in SQL
• SQL command quick reference guide
• Join Lecture Summary/Review Sheet   
• Storing Dates
• Number Date Notes
• Character, Number, Dates notes
• Character Case  Notes
  Section 7 & 8
• Group By Rules
• Group Functions
• Subquery notes
• Timestamp example
• DML Default and Merge Notes
• DML Insert Notes
  Sections 9 & 10
• Constraints Notes
• Constraints Type Notes
• Naming Constraints
• Object Summary Table

SQL Review Exams

• SQL Review Exam part 1     (Answers)
• SQL Review Exam part 2     (Answers)
• SQL Review Exam part 3     (Answers)
• SQL Review Exam part 4     (Answers)

Student_oracle_PL_SQL_resources.htm
last update:  08/26/2008