python anaconda update
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
Posts
python anaconda download
파이썬의 아나콘다 - Continuum Analytics이라는 곳에서 만든 파이썬 배포판 입니다 - 약 200개 정도의 파이썬 패키지를 포함 - 상업용으로도 사용가능 파이썬 아나콘다 다운로드 : https://www.continuum.io/downloads
Insert statements cannot be executed as a query
ERROR kr.go.elevator.rep.cont.service.impl.KeepMsMngServiceImpl SqlMapClient operation; uncategorized SQLException for SQL []; SQL state [null]; error code [0]; Insert statements cannot be executed as a query.; nested exception is java.sql.SQLException: Insert statements cannot be executed as a query. java.sql.SQLException: Insert statements cannot be executed as a query. at com.ibatis.sqlmap.engine.mapping.statement.InsertStatement.executeQueryForList(InsertStatement.java:40) at com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelegate.queryForList(SqlMapExecutorDelegate.java:567) at com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelegate.queryForList(SqlMapExecutorDelegate.java:541) at com.ibatis.sqlmap.engine.impl.SqlMapSessionImpl.queryForList(SqlMapSessionImpl.java:118) at org.springframework.orm.ibatis.SqlMapClientTemplate$3.doInSqlMapClient(SqlMapClientTemplate.java:298) at org.springframework.orm.ibatis.SqlMapClientTemplate.execute(SqlMapClientTemplate.java:209) at org.springfr...
ibatis insert all
alter table table_name drop column column_name <insert id="insep.insertkeepCont" parameterClass="java.util.List"> <![CDATA[ INSERT ALL ]]> <dynamic> <iterate conjunction=" "> <![CDATA[ INTO table_name (KEEP_NO , MGT_NO1 , MGT_NO2 , e_NO , SEL_CHK_MM ) VALUES ]]> (#[].keepNo# ,#[].mgtNo1# ,#[].mgtNo2# ,#[].eNo# ,#[].selChkMm# ) </iterate> <![CDATA[ SELECT * FROM DUAL ]]> </dynamic> </insert>
oracle max keep
MAX(COL_A)|MIN(COL_A) KEEP(DENSE_RANK FIRST|LAST ORDER BY COL_B [ASC|DESC]) <CH컬럼에 속한 데이터('Z') 중 RNUM의 MAX값을 구함> MAX값을 가져올때 다른 컬럼이 기준값이 되어 기준값이 된 컬럼의 순서에 따른 MAX를 찾아야 할 경우 max keep