SERPland Oracle, PL/SQL, PHP, Autos, Bungalow-Hotels and more …

Template Method Pattern implemented in PL/SQL

Design Pattern are great! Not just in Java or C#

The Template Method Pattern can also be implementet with Oracle's PL/SQL language (using clean Object Types).

The Template Method Design Patterns is probalby one of the most widely used and useful design pattern. common example of this is when writing a program that will handle data using various detail algorithms. The abstract Class would have a method called the "Template" Method which contains the main program logic. There also exists "helper method"s in the class, which are specified by any class that inherits from it.
So the abstract class defines the main logic. The subclasses itself implement the details logic. So every developer can implement his specific details without changing the main logic.

In PL/SQL this design pattern can be implementet the procedural way as been done by Lucas Jellema (Amis.nl)
Here I created a PL/SQL sample with Object Types:

drop type adress_o;
drop type adress_abstract_o;

Bookmark It