Problem #1: Write a PL/SQL program that includes the following:

• A cursor to hold records
• Only fill the cursor with records that meet specified criteria
• Process the records in the cursor one by one using an IF statement - records that meet specific criteria should be processed one way and then written to a new table/file. Records that meet another specific criteria should be processed another way and then written to a second new table/file.

For example:

You might decide to only process records where the state = MA. That selection could be handled with the cursor. You then might decide that if the city is Fall River you are going to do a calculation and write to the Fall River table. Other cities call for another calculation and get written to another table.

Problem #2: Write a PL/SQL program that uses TYPETABLE in some way.