Search This Blog

Saturday, November 25, 2017

Grade Query

SELECT  pg.grade_code "Grade name" ,
      pg.grade_code "Grade code",
       (SELECT set_name
          FROM fnd_setid_sets_vl
         WHERE set_id = pg.set_id)
          set_name,
          TO_CHAR (pg.EFFECTIVE_START_DATE,
                'DD-Mon-YYYY',
                'NLS_DATE_LANGUAGE=AMERICAN')
          "Effective Start Date",
          pg.ACTIVE_STATUS
  FROM per_grades_f pg

No comments:

Post a Comment