Case Statement Snippets


28 June, 2014   

Starting in Oracle 9i, you can use the case statement within an SQL statement. It has the functionality of an IF-THEN-ELSE statement.

27 May, 2014   

PL/SQL Code for a searched CASE statement

04 March, 2012   

Use the switch statement to select one of many blocks of code to be executed.

A simple DELETE statement in MSSQL

23 September, 2011   

An example Dates with the Ordinal Suffix . Below is the code that will do this.

This example has an ordinal suffix: Sunday 15th July

02 January, 2012   

The UPDATE statement is used to update existing records in a table

10 November, 2012   

It will return a string of words to represent the integer part of this value.

A JavaScript implementation of the famous sprintf() function

04 January, 2012   

SQL example Code for SELECT statement with HAVING clause

A simple INSERT statement in MSSQL with the various types of values.

05 May, 2012   

ASP code example with Sql Statement

24 June, 2015   

Create a table with the results from a SELECT statement.

16 March, 2011   

Take an image, and put a water mark on top of it. Note that you can only use this function once per page.

07 September, 2014   

The "WITH CHECK OPTION" is used to indicate that Oracle will prevent any changes to the table or view that would produce rows that are not included in the subquery. When used in the subquery of a DML statement, you can specify this clause in a subquery in the FROM clause but not in subquery in the WHERE clause.

04 December, 2011   

Example of If Statement in python

16 February, 2013   

Binds a php variable to an SQL statement using the bindParam() method

14 May, 2011   

This is a general code to use when deleting an item from a MySQL database. This code isn't considered definitive and can be written in many varied ways. A variation of the code would be not to delete the record (as you tend to always need to restore or retrieve it sooner or later) you can add a 'status' field. If status='d' then it is...

15 June, 2014   

Example for updating a record in a database with perl and the DBU module.

10 November, 2014   

Easy way to parses RSS into an array