Block Structure :A subprogram is based on standard pl/sql structure that contains a declarative section, an executable section and an optional exception handling section.
Modularity: Mopdularisation is the process of breaking up large blocks of code into smaller groups of code called modules.
It is easier to maintain and debug code of smaller modules than a single large program.
Extensibility : The modulues can be easily extended for customization by incorporating more functionality,
if required without affecting the remaining modules of the program.
Reusability : After the code is modularized, the modules can be reused by the same program or shared by other programs.
Maintainibility : Subprograms provide easy maintainance because the code is located in one place and hence any modifications required to the subprogram can be performed in this single location.
Improved data security and integrity and code clarity: subprograms provide improved data integrity and security . The data objects are accessed through the subprogram and a user can invoke the subprogram only if appropriate access priviledge is given to user.
Modularity: Mopdularisation is the process of breaking up large blocks of code into smaller groups of code called modules.
It is easier to maintain and debug code of smaller modules than a single large program.
Extensibility : The modulues can be easily extended for customization by incorporating more functionality,
if required without affecting the remaining modules of the program.
Reusability : After the code is modularized, the modules can be reused by the same program or shared by other programs.
Maintainibility : Subprograms provide easy maintainance because the code is located in one place and hence any modifications required to the subprogram can be performed in this single location.
Improved data security and integrity and code clarity: subprograms provide improved data integrity and security . The data objects are accessed through the subprogram and a user can invoke the subprogram only if appropriate access priviledge is given to user.
No comments:
Post a Comment