블로그
-
COMMA SUM
DECLARE @Table TABLE( ID INT, Vals VARCHAR(100) ) INSERT INTO @Table SELECT 1, '0.00,12.45,14.33' INSERT INTO @Table SELECT 2, '1,2,3,4' ;WITH ValList AS( SELECT ID, CAST(LEFT(Vals,PATINDEX('%,%', Vals) -
blog.naver.com · 2014.06.23
-
sum of comma separated values
@list VARCHAR(8000), @delim CHAR(1) = ',' ) RETURNS TABLE AS RETURN WITH csvtbl(START, stop) AS ( SELECT START = 1, stop = CHARINDEX(@delim COLLATE Slovenian_BIN2, @list + @delim) UNION ALL SELECT START =
blog.naver.com · 2014.06.18
-
PL_SQL 최종
: 변수, 상수, 커서, 예외 선언 v_empno number(10) ;= &p_empno; // 할당 연산자 v_sal number(10) ; begin // 실행절 select sal into v_sal from emp where empno = v_empno; dbms_output.put_line( ' 월급은 ' || v_sal); // 출력을 위한 오라클
blog.naver.com · 2014.07.07
-
DDL
Query -> select 문의 6가지 절 DML -> insert, update, delete, merge ============ DDL -> create, alter * from emp507; 229 위에서 생성한 EMP507 테이블에 DATA를 3건정도 입력하시오 INSERT INTO emp507 VALUES(7799,'.......
blog.naver.com · 2014.06.21
-
-실행문 -PL/SQL에서 DML 문 작성 - if 문 , loop 문
declare v_deptno emp.deptno%type := &p_deptno; v_sumsal emp.sal%type ; begin select sum(sal) into
blog.naver.com · 2014.06.25
-
PL/SQL
: 변수, 상수, 커서, 예외 선언 v_empno number(10) ;= &p_empno; // 할당 연산자 v_sal number(10) ; begin // 실행절 select sal into v_sal from emp where empno = v_empno; dbms_output.put_line( ' 월급은 ' || v_sal); // 출력을 위한 오라클
blog.naver.com · 2014.06.24
-
MODO 801 SP1 (2014-June-02) Details (build 71114) MODO 801 Known Issues List
Changing links into modifiers did not update the modifier chain. If you sculpted on a curve and tried to select the tip vertices after the sculpt, some ve.......
blog.naver.com · 2014.06.04
-
Apple 9L0-010 (Macintosh Service Certification Exam) 인증덤프
NO.1 Which TWO details are derived from entering an Apple product's serial number into the Online Service SELECT TWO A. Mac OS version B. Warranty status C. AppleCare name D. Installed memory E.
blog.naver.com · 2013.12.11
-
3일차(11월2일) 성적 처리 _메뉴 버전 (콘솔 기반 최종)
처리 _메뉴 버전 (콘솔 기반 최종) --------------------------------------INSERT 쿼리 샘플 (쿼리 끝 부분에 ; 표시하지 말 것)INSERT INTO score (sid, name, kor, eng, mat) VALUES (scoreSeq.nextval, 'hong', 100, 100, 100) --SELECT 쿼리 샘플 (쿼리
blog.naver.com · 2012.12.01
-
[Trigger]
UPDATE EXAMPLE> CREATE TRIGGER Employee_Trg_Upd ON emplyeeORG AFTER UPDATE AS INSERT INTO employeeTRK SELECT ID,FirstName,LastName FROM DELETED GO DML Trigger에 대해서. 1.Inserted 2.Deleted These tables are
blog.naver.com · 2012.10.11
