Homework 4 - part 2

Run the following queries in Oracle Application Express. Paste a copy of each query on a Microsoft Word document or notepad text file, save and return to your adjunct via email.

Database Programming - Section 4, Practice Guide

1. Review of Joins Try It / Solve It 1a, 1c, 1d, 2b, 2e
2. Group Functions, Try It / Solve It 2, 3
3. COUNT, DISTINCT, NVL, Try It / Solve It 1, 2

---

Database Programming - Section 5, Practice Guide

1. GROUP BY and HAVING Clauses, Try It / Solve It 2a, 2b, 2c, 2d, 5, 6
2. Using ROLLUP and CUBE Operations, and GROUPING SETS Try It / Solve It 1
3. Using SET Operators, Try It / Solve It 2

---

Zpět na stránku úkolů - part 2

Zpět na stránku Oracle Academy