turtle

update ="UPDATE TT_WORK SET IS_YN = 'Y' WHERE SEQ_NO= ?" cur.execute(update,(best_no)) cur.commit() cur.close() cur.execute(update, ( best_no ) ) ->  cur.execute(update, [ best_no ] )

conda --version conda update conda conda create -n py34 python=3.4 anaconda http: //microsoft-visual-cpp-express.soft32.com/ https://github.com/quantopian/zipline/releases

select update ---------------------------------------- UPDATE (SELECT A.ORDER_APPROVED AS ORDER_APPROVED ,A.MAKE_YEAR      AS MAKE_YEAR ,A.MAKE_NO        AS MAKE_NO ,A.UPDATE_USID    AS UPDATE_USID ,A.UPDATE_DT      AS UPDATE_DT ,A.MAKING_DATE    AS MAKING_DATE FROM   TB_ELVTRNO_ORDER A WHERE  A.ORDER_YN = 'Y' ) SET    ORDER_APPROVED = (ORDER_APPROVED + 1) ,UPDATE_USID    = #ORDER_USID# ,UPDATE_DT      = SYSDATE ,MAKE_YEAR      = TO_CHAR(SYSDATE, 'YYYY') ,MAKE_NO         =(SELECT DECODE(MAX(B.MAKE_NO), '', '01', LPAD(TO_NUMBER(MAX(B.MAKE_NO) + 1), 2, '0')) AS MAXMAKENO FROM TB_ELVTRNO_ORDER B WHERE MAKE_YEAR = TO_CHAR(SYSDATE, 'YYYY')) ,MAKING_DATE    = SYSDATE