Chapter 3 Test Your Thinking
Before starting these projects, take a look at the formatting guidelines in Appendix B. Make your variable names conform to the standard. At the top of the declaration section, put a comment stating which naming standard you are using.
Write a PL/SQL block
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 autoinitialized to the value ‘603D’
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 ...