Reviewing It

1:What does PL/SQL stand for?
2:What exactly is a stored procedure?
3:What is the difference between a Named PL/SQL block and an Un-named PL/SQL block?
4:What are the three syntax basics of any PL/SQL block?
5:The special datatype %TYPE is useful for what?
6:PL/SQL uses the DBMS_OUTPUT.PRINT_LINE. What needs to be set in SQL*Plus to see this output?
7:What are the three kinds of loops?
8:What are the two variables available to PL/SQL when Oracle errors occur?

Get Oracle9i™ Development by Example 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.