Calculate next (this) friday date with pl/sql – hide out!
Today I needed a PL/SQL funtion to determine next friday's date.
Therefore I had to write a strange PL/SQL function. I'm kind of mixed up - am I complicated?
I'm sure there's a pretty simple Oracle solution out there - hide out!
Hopefully Steven Feuerstein never sees this lines of code. Maybe someon has a better idea than this ....
Decorator Design Pattern in Oracle PL/SQL: Using Object Type with Constructor
As I did with the Template Method Design Pattern I also tried to implement the "Decorator" Design Pattern in Oracle's PL/SQL language.
| English | Deutsch/German |
|---|---|
The Book "Head First - Design Patterns" perfectly describes the Decorator pattern.
So I wrote some Object Type to implement the Decorator. I'd like to have a DRINK class (Espresso or Tea) with just one attribute called "description" and a method which returns the price.
There are some specific classes to make instances like an Espresso. Other classes are "adding" sugar or cream to my espresso.
I'd like to receive following result:
-- start with a Espresso --
descr= Espresso
price= 1
descr= Espresso, sugar
price= 1,2
descr= Espresso, sugar, Cream
price= 1,95-- start with a Tea --
descr= Tea
price= 3
descr= Tea, sugar
price= 3,2
descr= Tea, sugar, Cream
price= 3,95
Recent Posts
- Schreibwettbewerb: 14. Menülesung Thema: “Geschichten von der Strasse” (Bis 30. September 2010)
- Schreibwettbewerb für neue Autoren die sich mit Kinder- und Jugendbüchern – leider schon abgelaufen
- Familienautos: Vergleichstabelle Minivans, VANS, SUV’s
- I’ve installed WP-TABLE-RELOADED plugin for my wordpress, this is my first test with a family car comparisation table …
- Air Traffic Mashup: Flightradar24 – seeing real time air travel
Tags
Recent Comments
- Oliver on karate aber welches? shotokan, dentokan, shinkyokushinkai oder gar was anderes wie aikido?
- merry on Digitale Kompakt Kameras bis CHF 300 (EURO 200), F100fd, FX35, IXUS 90IS, Coolpix S610
Categories
- baubiologie
- Bungalow-Familien-Hotels
- cast-application-mining
- cruise lines
- deutsch
- ferien
- foto
- Hydrocephalus-Occlusivus-Shunt
- internet
- java/jsp
- legoland
- lifestyle
- misc
- no-tube-graz
- oracle
- regional
- RSI
- wordpress
- zurich