Oracle9i™ Development by Example

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