본문 바로가기

나 어제 배웠다

 (108)
DB2 MERGE 사용하기 오라클과 비슷한 문장 구조 Case1. MERGE INTO S2B.A AS NEW USING (SELECT KEY FROM S2B.B WHERE KEY = #key#) AS OLD ON NEW.KEY = OLD.KEY WHEN MATCHED THEN UPDATE SET WHEN NOT MATCHED THEN INSERT ( ) VALUES ( ) Case2. MERGE INTO S2B.A AS NEW USING (SELECT COUNT(KEY) CNT FROM S2B.A WHERE KEY = #key#) AS OLD ON 1 <= OLD.CNT AND NEW.KEY = #key# WHEN MATCHED THEN UPDATE S..
DB2 Byte 문자열 자르기(한글) select SUBSTR(REPLACE('년간1회금액입력,견적서금액상이,2회금액시2순위업체',' ',''),1,10)||'...' , SUBSTRING('년간1회금액입력,견적서금액상이,2회금액시2순위업체',1,10,CODEUNITS32)||'...' , SUBSTRING('년간1회금액입력,견적서금액상이,2회금액시2순위업체',1,10,CODEUNITS16)||'...' , SUBSTRING('년간1회금액입력,견..
[egovframe]전자정부 표준프레임워크 - 개발환경 프로그램 Download 개발환경 프로그램 Download 1. http://www.egovframe.go.kr/Main.do 접속 2. 개발 가이드 > 개발환경 메뉴 선택 3. 개발자용 개발환경 선택 4. 회원가입 후 로그인 5. eGovFrameDev-2.0.1-FullVer.zip 파일 다운 6. 다운완료된 파일을 개발 Directory에 압축 풀기
HTML5 Aptana Plug-in Install http://download.aptana.com/studio3/plugin/install
Random Select... Select a random row with MySQL:SELECT column FROM table ORDER BY RAND() LIMIT 1 Select a random row with PostgreSQL:SELECT column FROM table ORDER BY RANDOM() LIMIT 1 Select a random row with Microsoft SQL Server:SELECT TOP 1 column FROM table ORDER BY NEWID() Select a random row with IBM DB2SELECT column, RAND() as IDX FROM table ORDER BY IDX FETCH FIRST 1 ROWS ONLY Select a ..
Using MyBatis 3 with Spring 3 Using Mapper XML Files Using MyBatis 3 with Spring 3 Using Mapper XML Files Recently I started to work on design an application as a part of a new project assigned to me at my work place. Since this is totally a new application to be developed from scratch, I got liberty/flexibility to choose the tools/frameworks which will form the foundation of the application. With lots of frameworks to choose from and many choice..
ValidationForm Sample 필요 library 1. index.jsp <%@ page language="java" contentType="text/html; charset=UTF-8" pageEncoding="UTF-8"%> <!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd"> <html> <head> <meta http-equiv="Content-Type" content="text/html; charset=UTF-8"> <title>Spring 3, MVC Examples</title> </head> &lt..
SimpleForm ...

티스토리툴바