Applying It

Independent Exercise 1:

• Download the Chapter 11 examples from www.quepublishing.com.
  
  
• Build the PL/SQL procedures getcar and makeoffer.
  
  
• Build a simple PSP that gets the first record from getcar.
  
  

Independent Exercise 2:

• Download the java bean programs from www.quepublishing.com.
  
  
• Compile the java bean programs.
  
  
• Build a simple JSP that gets the first record from getcar.
  
  

Independent Exercise 3:

• Download the cell phone emulator from www.phone.com.
  
  
• Build a simple XML application using the following query:
  
  

  Select DNAME, SUM(SAL)
  From EMP, DEPT
  Where EMP.DEPTNO = DEPT.DEPTNO