[교육] SQL초보에서실전전문가까지 ORACLE - 8 Composite Type 변수 만들기DECLARE TYPE name_table_type IS TABLE OF emp.ename%TYPE INDEX BY BINARY_INTEGER; name_table name_table_type; begin name_table(1) := 'KKKK'; name_table(2) := 'HHHH'; insert into emp(empno, ename) values (5151, name_table(1)); insert into emp(empno, ename) values (6161, name_table(2)); --// 내부에 commit 넣어줄 수 있음. commit; end; select * from emp; 테이블변수 만들기DECLARE TYPE EMP_RECORD_T.. 더보기 Oracle START WITH ~ CONNECT BY 절 MSSQL로 처리하기 굉장히 정리가 잘된 START WITH ~ CONNECT BY 예제 * Oracle START WITH ~ CONNECT BY 절 MSSQL로 처리하기. # OracleSELECT LEVEL, CATE_ID, LTRIM (SYS_CONNECT_BY_PATH (CATE_NAME, ' > '), ' > ') || ' > ' AS CATE_NAME FROM TBL_CATEGORYSTART WITH CATE_ID = 1CONNECT BY PRIOR CATE_ID = PARENT_CATE_ID # SQL ServerWITH CTE_TABLEAS( SELECT 1 AS LEVEL, A.CATE_ID, PARENT_CATE_ID, CATE_NAME, CONVERT(VARCHAR(100),CAST(A.CATE_NAME.. 더보기 이전 1 ··· 13 14 15 16 17 18 19 ··· 40 다음