Chapter 5 Assignment - Lemuel Taku ITD 134 Class 15 Homework Chapter 5 Review Questions 1D 2 A B C 3 C 4 C D 5 A C 6C 7 C 8C 9B 10 C 11 A named program

Chapter 5 Assignment - Lemuel Taku ITD 134 Class 15...

This preview shows page 1 - 4 out of 33 pages.

Lemuel Taku ITD 134 Class #: 15 Homework Chapter 5 Review Questions C C 11 – A named program unit is a PL/SQL code block with a name. It consists of three parts:Declaration Part - Defining the program unit name, calling parameters, local variables and local procedures. Declaration part is required.Execution Part - Defining execution logic with executable statements. Execution part is required.Exception Part - Defining error handling logics. Exception part is optional.There are two types of named program units:Procedure - Has no return values.Function - Has a return value.12 The output from the calls to put_line( ) give you enough information to find out how the procedure runs and what values are stored in variables at different times. Had the procedure failed during execution, you would know the line it failed on depending on what output was produced and what output was not produced.
Image of page 1
Image of page 2
Image of page 3
Image of page 4

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture