Prentice Hall Oracle Plsql By Example 3Rd Edition [Electronic resources] نسخه متنی

That includes declarations for the following variables:

A VARCHAR2 data type that can contain the string 'Introduction to Oracle PL/SQL'

A NUMBER that can be assigned 987654.55, but not 987654.567 or 9876543.55

A CONSTANT (you choose the correct data type) that is auto-initialized to the value '603D'

A BOOLEAN

A DATE data type autoinitialized to one week from today

In the body of the PL/SQL block, put a DBMS_OUTPUT.PUT_LINE message for each of the variables that received an autoinitialization value.

In a comment at the bottom of the PL/SQL block, state the value of your NUMBER data type.

Remove the DBMS_OUTPUT.PUT_LINE messages.

In the body of the PL/SQL block, write a selection test (IF) that does the following (use a nested IF statement where appropriate):

Check whether the VARCHAR2 you created contains the course named 'Introduction to Underwater Basketweaving'.

If it does, then put a DBMS_OUTPUT.PUT_LINE message on the screen that says so.

If it does not, then test to see if the CONSTANT you created contains the room number 603D.

If it does, then put a DBMS_OUTPUT.PUT_LINE message on the screen that states the course name and the room number that you've reached in this logic.

If it does not, then put a DBMS_OUTPUT.PUT_LINE Message on the screen that states that the course and location could not be determined.

Add a WHEN OTHERS EXCEPTION that puts a DBMS_OUTPUT.PUT_LINE message on the screen that says that an error occurred.