Lab5

--SELECT LAST_NAME, TO_CHAR(BIRTHDATE,'Month DD, YYYY') FROM F_STAFFS;
--SELECT TO_DATE('January 03, 2004','Month dd, YYYY') FROM dual;
--SELECT CODE, ' The promotion began on the '||TO_CHAR(START_DATE,'ddthsp "of" fmMONTH YYYY')FROM F_PROMOTIONAL_MENUS WHERE CODE=110;
--SELECT EMPLOYEE_ID, FIRST_NAME, TO_CHAR(SALARY,'$999999.99')FROM EMPLOYEES;
--SELECT FIRST_NAME, LAST_NAME, SALARY AS "CURRENT SALARY",TO_CHAR(SALARY +2000,'$9999999.99') AS"NEW SALARY" FROM EMPLOYEES WHERE UPPER(FIRST_NAME) ='ELLEN' AND UPPER(LAST_NAME) ='ABEL';
--SELECT TO_CHAR(TO_DATE('25-Dec-2004','dd-Mon-yyyy'),'dd Month, YYYY')FROM dual;
--SELECT NAME, START_DATE, END_DATE, NVL2(END_DATE, 'end in two weeks',SYSDATE)FROM F_PROMOTIONAL_MENUS;
--SELECT LAST_NAME,NVL(OVERTIME_RATE,0) AS "OVERTIME STATUS" FROM F_STAFFS;
--SELECT LAST_NAME, FIRST_NAME, CASE TO_CHAR(HIRE_DATE,'Month') WHEN 'September' THEN NULL ELSE TO_CHAR(HIRE_DATE,'Month') END FROM EMPLOYEES;
--SELECT TITLE, CASE DURATION WHEN '2 min' THEN 'SHORTEST' WHEN '10 min' THEN 'LONGEST' END FROM D_SONGS;