Oracle® PL/SQL® Interactive Workbook, Second Edition

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.

1)

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 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 ...