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 compiled code will be marked invalid. After recompilation, your code automatically reflects the latest structure in the table. When you anchor against a PL/SQL variable, you make sure to define your type of data only once and then reuse that definition. So if the definition changes, you have to change your code in only one place.
1-14.	Name at least three different objects to which you could anchor a variable.
1-15.	What datatype would you expect a function of the name “is_value_in_list” to return?