다중row를 컬럼으로 변경 (ORACLE) ------------------------------- -- 1번째 방법 : XMLAGG ------------------------------- - 예제 WITH T1 AS ( SELECT 'A' AS COL1 FROM DUAL UNION ALL SELECT 'B' FROM DUAL UNION ALL SELECT 'C' FROM DUAL UNION ALL SELECT 'D' FROM DUAL UNION ALL SELECT 'D' FROM DUAL ) SELECT SUBSTR(XMLAGG(XMLELEMENT(A, ',' || COL1) ORDER BY COL1).EXTRACT('//text()'), 2) FROM T1; ----------------------------------------------.. 더보기 유용한 sql -- 테이블스페이스 삭제 -- 테이블스페이스가 오프라인으로 상태에서 명령을 내리길 권장 DROP TABLESPACE unicorn_temp INCLUDING CONTENTS CASCADE CONSTRAINTS; -- DATA TABLESPACE 생성 CREATE TABLESPACE unicorn_data DATAFILE 'D:\oracle\oradata\unicorn_data.TBL' SIZE 100M AUTOEXTEND ON NEXT 10M MAXSIZE 500M DEFAULT STORAGE (INITIAL 4K NEXT 128K MINEXTENTS 1 PCTINCREASE 0); -- INDEX TABLESPACE 생성 CREATE TABLESPACE unicorn_index DATAFILE 'D:\.. 더보기 JDBC Connection Url Samples and Patterns for JDBC Drivers Oracle JDBC Driveroracle.jdbc.driver.OracleDriverjdbc:oracle:thin:@{hostname}[:port]:{database} Example: jdbc:oracle:thin:@hostname:1521:dbname IBM DB2 JDBC Drivercom.ibm.db2.jcc.DB2Driverjdbc:db2://{hostname}{:port}/{database} Example: jdbc:db2://hostname:50000/dbname:retrieveMessagesFromServerOnGetMessage=true; COM.ibm.db2.jdbc.net.DB2Driverjdbc:db2://{hostname}[:port]/{database} Example: jdbc.. 더보기 이전 1 ··· 8 9 10 11 12 13 14 ··· 26 다음