SQL

Sql code posted
created at 26 Nov 22:15

Edit | Back 
1
2
3
4
 
UPDATE PS_ADM_APPL_PROG SET EFFDT = '01-JAN-06' WHERE EMPLID = '020203649' AND ADM_APPL_NBR = '00013882' AND EFFDT = '03-JAN-06';
UPDATE PS_ADM_APPL_PLAN SET EFFDT = '01-JAN-06' WHERE EMPLID = '020203649' AND ADM_APPL_NBR = '00013882' AND EFFDT = '03-JAN-06';
UPDATE PS_ADM_APPL_PLAN SET DECLARE_DT = '01-JAN-06' WHERE EMPLID = '020203649' AND ADM_APPL_NBR = '00013882' AND DECLARE_DT = '03-JAN-06';
UPDATE PS_ACAD_PROG SET ADM_APPL_NBR = '00013882' WHERE EMPLID = '020203649' AND ACAD_CAREER = 'GRAD' AND EFFDT = '01-JAN-06';
530 Bytes in 2 ms with coderay