Applying It

Independent Exercise 1:

• Build a simple Portal Application Form based on the EMP table.
  
  
• Query KING.
  
  
• Query all those making more than $2,000.
  
  

Independent Exercise 2:

• Build a Portal Application Report based on
  
  SELECT DNAME, SUM(SAL)
  
  FROM DEPT, EMP
  
  WHERE DEPT.DEPTNO = EMP.DEPTNO
  
  

Independent Exercise 3:

• Build a portal page with three columns.
  
  
• Populate these columns with various portlets.
  
  
• Run this newly created page.