Case 1: Reviewing Oracle SQL Developer Documentation
In this course, you will use SQL Developer as the primary tool to write PL/SQL code. Hence, it is important for you to get familiar with the tool.
Visit OTN (Oracle Technology Network) web site or search on the net for “Oracle SQL Developer – User’s Guide”. Review the document and describe at least two features that you think will be helpful in creating PL/SQL code.
Case 3: Working with More Movie Rentals
The More Movie Rentals Company wants to display a rating value for a movie based on the number of times the movie has been rented. The rating assignments are outlined in Table 1.
- Create a PL/SQL block to address the processing needed. The block should determine and then display the correct rental rating. Test the block, using a variety of rental amounts.