Answers to Chapter 3

Reviewing It

1: What does PL/SQL stand for?
A1: Procedural Language SQL
2: What exactly is a stored procedure?
A2: A stored procedure is a code module that does some processing and returns a code stating that the procedure was successful or not
3: What is the difference between a Named PL/SQL block and an Un-named PL/SQL block?
A3: Named PL/SQL blocks can be called in the form of procedures or functions, un-named PL/SQL are imbedded in applications
4: What are the three syntax basics of any PL/SQL block?
A4: Begin, Exceptions, End
5: The special datatype %TYPE is useful for what?
A5: %TYPE is useful to guarantee that the datatype and ...

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.