Enterprise Architect (EA) – UML model with Use Case Metrics – pragmatic approach
Great! In Sparx System's Enterprise Architect you can model UML and also take advantage of the Use Case Metrics.
Using metrics in software developement projects is essential!
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 ....
With Oracle10g Database many new features on case-, accent- and linguistic idependent query and sort functions
Some really nice additional functionallty for sql and pl/sql developers has been shipped with Oracle10g.
Ever tried to search for almost similar string matching?
With Oracle10g's new database linguistic sort functions you can do it!
How to set up / enable linguistic sorting
alter session set NLS_COMP=ANSI;alter session set NLS_SORT=GENERIC_BASELETTER;Burleson Consulting - Oracle10g case insensitive index searches
ALTER SESSION SET NLS_COMP=ANSI;
ALTER SESSION SET NLS_SORT=GENERIC_BASELETTER;http://sql-tips.de/index.php/Gro%C3%9F-/Kleinschreibung_bei_der_Suche_ignorieren
ALTER SESSION SET NLS_SORT='GENERIC_M_AI';http://forums.oracle.com/forums/thread.jspa?messageID=1325991
About linguistic sorting on Oracle Docs
http://download-uk.oracle.com/docs/cd/B10501_01/server.920/a96529/ch4.htm
http://download-uk.oracle.com/docs/cd/B14117_01/server.101/b10749/ch5lingsort.htm
Recent Posts
- Air Traffic Mashup: Flightradar24 – seeing real time air travel
- D: Dokumentation TOAD for Oracle (Datenbank Werkzeug)
- Chalkidiki: Hotel Xenia **** (griechische Halbinsel)
- Kreta: Hotel Vantaris Beach ****
- Teneriffa: Hotel Lagos de Fanabe ***+
Tags
Recent Comments
- Owen Murphy on All 9 Wordpress/WP Plugins to make money with Amazon (with your partner id)!
- cialis injury attorney ohio on Design Patterns in PL/SQL (Oracle)
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