Oracle PL/SQL Programming: A Developer's Workbook

Intermediate

1-7.	Declare a local variable to have the same datatype as the dollar_amount variable in the types package.
1-8.	Which of the following statements about the DATE datatype are true? The maximum (latest) date allowed in a date variable is January 1, 4712. The earliest date allowed in a date variable is January 1, 4712 BC (or BCE). A date variable contains both date and time information. A date variable records the time down to the nearest hundredth of a second. The DATE datatype stores only those numbers of digits for the year you specify when you assign a value to the variable.
1-9.	Declare a local variable to have the same datatype as the dollar_amount_t SUBTYPE in the types package.
1-10.	Explain what is wrong with the following anchored declaration: DECLARE dollar_amt CONSTANT NUMBER (20, 2) := 0; other_dollar_amt dollar_amt%TYPE;
1-11.	Explain what is wrong with the following SUBTYPE declaration: DECLARE SUBTYPE small_number IS NUMBER (3);
1-12.	What error is raised when you try to execute this block of code? What is the problem? DECLARE your_choice SIGNTYPE := 2; BEGIN NULL; END;
1-13.	Which of the following statements describe accurately how the “anchoring” of a variable’s datatype to a data structure improves the maintainability of that code? To anchor, you have to use %TYPE or %ROWTYPE, which involves more typing and that means you have more time to think about what you are typing and can get it right. If you anchor against a table or column in a table, when that table changes, your ...