본문 바로가기

전체 글415

Oracle MERGE INTO(1/1) 1. 설명(1/1) MERGE INTO 테이블명 alias USING [테이블명 | 뷰명 | subquery] alias ON 조건 WHEN MATCHED THEN UPDATE SET ... WHEN NOT MATCHED THEN INSERT ... VALUES ...; 1.설명(1/2) MERGE INTO table_name alias --테이블 명만 올수 있음(셀렉트 쿼리 No) USING (table|view|subquery) alias --일반적으로 쓰는 쿼리 Ok ON (join condition) --where 절이라고 생각하면됨(조건에 서브 OK) WHEN MATCHED THEN --데이터 중복건이 있는경우 Update UPDATE SET col1 = val1[, col2 = val2…] W.. 2010. 2. 7.
SQL(ORACLE) 여러 행의 특정 컬럼값 -> 하나의 컬럼으로 합치기 connect by prior / sys_connect_by_path with t as ( select 1 key1, '가' key2, '나' key3, 10 key4 from dual union all select 2 key1, '가' key2, '나' key3, 20 key4 from dual union all select 3 key1, '다' key2, '라' key3, 30 key4 from dual union all select 4 key1, '다' key2, '라' key3, 40 key4 from dual union all select 5 key1, '다' key2, '라' key3, 50 key4 from dual union all select 6 key1, '마' key2, '바' key.. 2010. 2. 3.
EJB3 미정 package com.hacsa.ejb3.board; import java.io.Serializable; import java.util.Date; import javax.persistence.*; @NamedQueries({ @NamedQuery( name="findBoard", query="SELECT o FROM BoardEntity o" ) }) @SqlResultSetMapping(name="BoardResults", entities={ @EntityResult(entityClass=com.hacsa.ejb3.board.BoardEntity.class) // ,@EntityResult(entityClass=ejbql.models.Customer.class) } ) @Entity @Table(nam.. 2009. 3. 11.
Spring applicatioContext-*** 10000000 E:\Temp\fileupload\upload\ boardController getRateMasterList goCreateUpdateRateMasterPage getRateMasterDetail deleteRateMaster udpateRateMasterDetail createRateMasterDetail goRateMasterRegist goConditionSearch goCreateRateResultPage createRateResult getRateResult getYearInfo realOverAllDelete E:\Temp\fileupload\upload\ org.springframework.web.servlet.view.JstlView .jsp 2009. 1. 8.
728x90

티스토리툴바