Intermediate
Q: | |
1-7. | Use the %TYPE anchoring attribute against a PL/SQL variable, just as you would anchor to the column of a table: CREATE OR REPLACE PACKAGE types IS dollar_amount NUMBER(20,2); END; / DECLARE my_dollars types.dollar_amount%TYPE; BEGIN ... END; |
Q: | |
1-8. | The statements about the DATE datatype are:
|
Q: | |
1-9. | The thing to remember when using a SUBTYPE is that you do not include a %TYPE anchoring attribute. A subtype already is a type. Here is the solution: CREATE OR REPLACE PACKAGE types IS SUBTYPE dollar_amount_t IS NUMBER; END; / DECLARE my_dollars types.dollar_amount_t; BEGIN ... END; |
Q: | |
1-10. | You can’t anchor (use %TYPE) against a CONSTANT; it must be a variable. |
Q: | |
1-11. | Unlike the folks who wrote the PL/SQL language, we developers are not allowed to “constrain” our own SUBTYPEs. In other words, after the IS keyword you cannot supply a datatype declaration that limits the size or length explicitly. Note that this restriction is relaxed in Oracle8i . |
Q: | |
1-12. | You receive this error: ORA-06502: PL/SQL: numeric or value error because a variable assigned the type SIGNTYPE can have only one of three ... |
Get Oracle PL/SQL Programming: A Developer's Workbook now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.