Lab 19.3 Exercises


19.3.1 Use Collections of Records

In this exercise, you will learn more about collections of records.

Answer the following questions:

a)

Modify the script used earlier in this lab. Instead of using index-by table, use nested table.

b)

Modify the script used earlier in this lab. Instead of using index-by table, use a varray.

c)

Modify the script used earlier in this lab. Instead of using a cursor-based record, use a user -defined record. The new record should have three fields: first_name , last_name , enrollments . The last field will contain total number of courses in which a student is currently enrolled.




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