Eg Net Solution: oracle

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

    Showing posts with label oracle. Show all posts
    Showing posts with label oracle. Show all posts

    Monday, April 11, 2016

    Essential Oracle/SQL Query

    April 11, 2016 0
    Essential Oracle/SQL Query
    Posted by at No comments:
    Labels: ,

    Wednesday, March 30, 2016

    Understanding SQL/Oracle Group join and aggregate function

    March 30, 2016 0
    Understanding SQL/Oracle Group join and aggregate function
    Posted by at No comments:
    Labels: ,

    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.
    Posted by at No comments:
    Labels:

    Add Choice