SELECT SUM(OGN_PRC_STD_TRD_AMT+PRFT_GAIN_OGN_PRC)+4500000 FROM ANGEL.TB_IL1010D WHERE  REG_EMPNO = 'EXCEL'


SELECT SUM(OGN_PRC_STD_TRD_AMT+PRFT_GAIN_OGN_PRC) FROM ANGEL.TB_IL1010D

SELECT * FROM ANGEL.EXCEL WHERE B = '노바토'



SELECT * FROM ANGEL.TB_IL1010D WHERE CNTRNO = 'I20120013' AND REG_EMPNO = 'EXCEL'  --아이앤컴바인

SELECT * FROM ANGEL.TB_IL1010D WHERE CNTRNO = 'I20130122' AND REG_EMPNO = 'EXCEL' AND TRD_DT = '20151127' -- 에이프릴

SELECT * FROM ANGEL.TB_IL1010D WHERE CNTRNO = 'I20130123' AND TRD_CD = 'PA' --실리콘큐브

SELECT * FROM ANGEL.TB_IL1010D WHERE CNTRNO = 'I20130156' AND TRD_CD = 'PA' --짜이서울

SELECT * FROM ANGEL.TB_IL1010D WHERE CNTRNO = 'I20130159' AND TRD_CD = 'PA' --스캐터랩

SELECT * FROM ANGEL.TB_IL1010D WHERE CNTRNO = 'I20120042' AND TRD_CD = 'PC' AND TRD_DT = '20150430' AND TRD_SEQ=15      --버튼테크놀로지


SELECT * FROM ANGEL.TB_IL1010D WHERE CNTRNO = 'I20120070' AND TRD_CD = 'PA'  --북팔
--I20120070

SELECT * FROM ANGEL.TB_IL1010D WHERE CNTRNO = 'I20140185' AND TRD_DT= '20141231'            --노바토

SELECT * FROM ANGEL.TB_IL1010D WHERE CNTRNO = 'I20140259'

SELECT * FROM ANGEL.TB_IL1009M WHERE CNTRNO = 'I20140259'

SELECT * FROM ANGEL.TB_SY1011M WHERE CUST_NO = '1000000243'

UPDATE ANGEL.TB_IL1010D 
SET       MODY_EMPNO='EXCEL_DEL1'
,         MODY_DTM = SYSDATE
,         DEL_YN = '1'
WHERE CNTRNO IN ('I20120013') 
AND REG_EMPNO = 'EXCEL';

UPDATE ANGEL.TB_IL1010D 
SET       MODY_EMPNO='EXCEL_DEL1'
,         MODY_DTM = SYSDATE
,         DEL_YN = '1'
WHERE CNTRNO = 'I20130122' AND REG_EMPNO = 'EXCEL' AND TRD_DT = '20151127';

UPDATE ANGEL.TB_IL1010D 
SET MODY_EMPNO='EXCEL_DEL1'
,         MODY_DTM = SYSDATE
,         DEL_YN = '1'
WHERE CNTRNO = 'I20130123' AND TRD_CD = 'PA' 
;

UPDATE ANGEL.TB_IL1010D 
SET MODY_EMPNO='EXCEL_DEL1'
,         MODY_DTM = SYSDATE
,         DEL_YN = '1'
WHERE CNTRNO = 'I20130156' AND TRD_CD = 'PA';

UPDATE ANGEL.TB_IL1010D 
SET MODY_EMPNO='EXCEL_DEL1'
,         MODY_DTM = SYSDATE
,         DEL_YN = '1'
WHERE CNTRNO = 'I20130159' AND TRD_CD = 'PA' 
;

UPDATE ANGEL.TB_IL1010D 
SET MODY_EMPNO='EXCEL_DEL1'
,         MODY_DTM = SYSDATE
,         DEL_YN = '1'
WHERE CNTRNO = 'I20120042' AND TRD_CD = 'PC' AND TRD_DT = '20150430' AND TRD_SEQ=15    ;


UPDATE ANGEL.TB_IL1010D 
SET       MODY_EMPNO='EXCEL_DEL1'
,         MODY_DTM = SYSDATE
,         DEL_YN = '1'
WHERE CNTRNO = 'I20120070' AND TRD_CD = 'PA'; 

UPDATE ANGEL.TB_IL1010D
SET              MODY_EMPNO='EXCEL_DEL1'
,         MODY_DTM = SYSDATE
,         DEL_YN = '1'
 WHERE CNTRNO = 'I20140185' AND TRD_DT= '20141231' ;