However, I'd like you to disregard what the textbook instructions indicate about "eliminating the DD_STATUS table". Instead, when the function receives a status ID value, it should reference the DD_STATUS table to determine the description to return. This still allows SELECT statements to be executed without using a JOIN statement. When constructing your SELECT statements, make sure that descriptive column headings are displayed.

For the 2nd SELECT statement that displays the requested information for only a specified pledge, I do NOT want you to use a constant value on the WHERE clause. Rather, use a substitution variable that will prompt the user to input a Pledge ID number. Remember from CIS3332 that a substitution variable in an SQL command instructs Oracle to substitute a value in place of the variable at the time the command is actually executed. To include a substitution variable, simply enter an ampersand (&) followed by the name used for the variable. For the purposes of this assignment, assume that the user will only enter valid pledge IDs.

Assignment 6-11: Identifying Pledge Status The DoGood Donor organization decided to reduce SQL join activity in its application by eliminating the DD STATUS table and replacing it with a function that returns a status description based on the status ID value. Create this function and name it DD PLSTAT SF. Use the function in an SQL statement that displays the pledge ID, pledge date, and pledge status for all pledges. Also, use it in an SQL statement that displays the same values but for only a specified pledge. Assignment 6-11: Identifying Pledge Status The DoGood Donor organization decided to reduce SQL join activity in its application by eliminating the DD STATUS table and replacing it with a function that returns a status description based on the status ID value. Create this function and name it DD PLSTAT SF. Use the function in an SQL statement that displays the pledge ID, pledge date, and pledge status for all pledges. Also, use it in an SQL statement that displays the same values but for only a specified pledge