Sql Statement Snippets


30 January, 2012   

The PL SQL code samples making use of the control structures will be given in the following.

This code will break a string of words up along the spaces and do a mySQL search for each of the words in the string.

This code will break a string of words up along the spaces and do a mySQL search for each of the words in the string.

09 February, 2011   

Class to back up entire databases and email them out, or individual tables.

This stored sql procedure is used to replace a special character (or string) of your field with another string.

Whenever a row is inserted in the Customers Table, the following trigger will be executed.

11 March, 2015   

PHP code shows how to upload images into a mysql database using

PL/SQL code example to create and call an oracle function

A simple and practical way to show the format of the IEEE standard for binary floating-point numbers (IEEE 754) is to use a union, as shown in the following example:

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.

MySQL code to find all duplicates in a database column(s)n.

20 April, 2013   

You can create your own Exceptions in PL/SQL

01 October, 2011   

An example of Variable Names in PL SQL

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

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.