My Sql Dump Snippets


08 May, 2013   

Shred attribute values out of an XML Variable in SQL 2008

03 May, 2012   

MYSQL code example for calculation of Easter Day This code taken from en.wikipedia.org

Oracle PL/SQL example for avoiding overlapping months and years

07 August, 2014   

All hints except /*+ rule */ cause the CBO to be used. Therefore, it is good practise to analyze the underlying tables if hints are used (or the query is fully hinted.

30 October, 2013   

Find a key from a list of values​​. parameters: sbValues​​: List of Values 'A;B;C;D' sbToken: Key 'B' sbSeparator: ',' or any defined sbValues

09 August, 2015   

Handy routine to display the database's SGA statistics.