Sql Group By Snippets

05 September, 2011   

This class is for simplifying and accelerating working with SQL, using this class is very simple; there is a sample below for this class, which I hope is useful.

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

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

C++ Example code to convert a real number to the string

Converts the given floating-point value to a zero-terminated string. The supplied buffer should be large enough to accommodate the converted value. The value includes a decimal point and possiblesign and exponent information, plus a terminating null character, which is appended automatically. Returns: a pointer to zero-terminated...

11 April, 2011   

Specifications of the TOPIC database format, a standardized structure for plain text databases that's easy to read and edit in most text editors, and easy to programmatically parse as well.

09 August, 2015   

Handy routine to display the database's SGA statistics.