2015 - Eg Net Solution

Here in this sites web and software developer can get some essential information.

MY Favorite .Net Question For Interview

This are not tidy. Just for rough. In Sha Allah will make it tiddy soon. 1.  DateTime2 Date range 0001-01-01 through 9999-12-31  vs Date...

Users Countries


Monday, November 30, 2015

Oracle CASE Practice

November 30, 2015 0
Oracle CASE Practice

SELECT CODE, CASE(NAME_EN) 
WHEN 'Teacher' then 'Head Teacher' 
WHEN 'Maulna' then 'Head Maulana' 
ELSE NAME_EN
END  TITLE_EGLISH
FROM IMS_SETUP_DESIGNATION_TO;

Here  NAME_EN is a column of  IMS_SETUP_DESIGNATION_TO table but it also may be a variable.

Add Choice