Chapter 20 Test Your Thinking


The projects in this section are meant to have you utilize all of the skills that you have acquired throughout this chapter. The answers to these projects can be found at the companion Web site to this book, located at http://authors.phptr.com/rosenzweig3e. Visit the Web site periodically to share and discuss your answers.

In this chapter, you learned about native dynamic SQL. Here are some projects that will help you test the depth of your understanding.

1)

Create a stored procedure based on the script ch20_1c.sql (version 3), created in the first lab of this chapter. The procedure should accept two parameters to hold a table name and an ID, and should return six parameters with first name, last name , street, city, state, and zip information.

2)

Modify procedure created in the previous exercise. Instead of using six parameters to hold name and address information, the procedure should return a user -defined record that contains six fields that hold name and address information. Note: You may want to create a package where you define record type. This record may be used later, for example, when the procedure is invoked in a PL/SQL block.





Oracle PL[s]SQL by Example
Oracle PL[s]SQL by Example
ISBN: 3642256902
EAN: N/A
Year: 2003
Pages: 289

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net