Difference between revisions of "Homework 4 - part 2"

From Wikivyuka
Jump to: navigation, search
 
m
 
(One intermediate revision by the same user not shown)
Line 6: Line 6:
 
#Group Functions, Try It / Solve It 2, 3  
 
#Group Functions, Try It / Solve It 2, 3  
 
#COUNT, DISTINCT, NVL, Try It / Solve It 1, 2
 
#COUNT, DISTINCT, NVL, Try It / Solve It 1, 2
 +
<hr>
  
 +
Database Programming - Section 5, Practice Guide
 +
 +
#GROUP BY and HAVING Clauses, Try It / Solve It 2a, 2b, 2c, 2d, 5, 6
 +
#Using ROLLUP and CUBE Operations, and GROUPING SETS Try It / Solve It 1
 +
#Using SET Operators, Try It / Solve It 2
 
<hr>
 
<hr>
  

Latest revision as of 12:41, 16 March 2011

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