Programming PL/SQL Objects
Declaring PL/SQL Variables
DBMS Output Line
PL/SQL var bind host
Creating Naming Convention
PL/SQL Datatypes - Quiz
Implicit Datatype Conversions
PL/SQL Block Conclusion
Writing Control Structures
PL/SQL Control Structures
Control Structures - Quiz
Composite Types Explained
Using Explicit Cursors
Implicit Cursor Guidelines
Explicit Cursor Guidelines
PL/SQL Block Goto Statement - Exercise
Create a PL/SQL block with labels and a GOTO statement
Identify the use of labels and the GOTO statement.
This exercise is worth a total of 25 points. You will receive up to 10 points for submitting the correct code to build the PL/SQL block using labels and the
statement. You will receive up to 10 points for submitting the code without using labels and the
statement. You will receive up to 5 points for explaining which you prefer and why.
e-pet.com has hired you for your PL/SQL skills. Before the store can sell pets online, it requires your immediate assistance to build a PL/SQL block that will look for the last pet product sold and list the first name of the customer who purchased it.
field from the CUSTOMER_SALE table to identify the latest pet product sold.
field from the CUSTOMER table to get the name of the customer.
Build this block using labels and the
Build this block without the use of labels and the
Explain what style of code you prefer and why.
Download the PETSTORE schema files from the following link.
Submitting your exercise
Once you have written your PL/SQL block, place it in the text area below and click the
button to submit the exercise.