Over 10 Million Study Resources Now at Your Fingertips

Download as :
Rating : ⭐⭐⭐⭐⭐
Price : $10.99
Pages: 2

Declares local procedure procedure show date date begin dbms date

Local or Nested Modules

A local or nested module is a procedure or function that is defined in the declaration section of a PL/SQL block (anonymous or named). This module is considered local because it is defined only within the parent PL/SQL block. It cannot be called by any other PL/SQL blocks defined outside that enclosing block.

PROCEDURE show_date (date_in IN DATE) IS
DBMS_OUTPUT.PUT_LINE (TO_CHAR (date_in, 'Month DD, YYYY'); END show_date;


Local or Nested Modules | 619

To improve the readability of your code
Even if you do not repeat sections of code within a module, you still may want to pull out a set of related statements and package them into a local module. This can make it easier to follow the logic of the main body of the parent module.

The following sections examine these benefits.

620 |

Chapter 17: Procedures, Functions, and Parameters

How It Works
Login account
Login Your Account
Add to cart
Add to Cart
Make payment
Document download
Download File
Uploaded by :
Page 1 Preview
declares local procedure procedure show date date
Sell Your Old Documents & Earn Wallet Balance