1 SELECT Job_ID, 2 TO_CHAR(effective_start_date,'dd-Mon-yyyy') AS ESD, 3 TO_CHAR(effective_end_date,'dd-Mon-yyyy') AS EED, 4 JOB_NAME, 5 MIN_SAL, 6 MAX_SAL, 7 STATUS, 8 JOB_LEVEL, 9 MED_CHECK_REQ AS MED_CHECK 10 FROM de_jobs 11 WHERE job_id=100000020529001 12 ORDER BY effective_start_date;