Sql Syntax Snippets

17 September, 2014   

PHP example code for using MySQL and a contact form to allow a group of users on a site to contact each other safely.

20 April, 2013   

You can create your own Exceptions in PL/SQL

01 October, 2011   

An example of Variable Names in PL SQL

17 December, 2011   

We can use the following SELECT statement with AND & OR Operators

MS SQL triggers for automatic Create and LastModified Dates

07 December, 2013   

Example code for Oracle Cursor Query

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.