SQL 세로를 가로로 만들기 참조...
1) 세로를 가로의 데이터로 만들기 /* Formatted on 2010/10/07 14:11 (Formatter Plus v4.8.8) */WITH tmp AS (SELECT '1' AS col1, 'A' AS col2 FROM DUAL UNION ALL SELECT '2' AS col1, '가' AS col2 FROM DUAL UNION ALL SELECT '1' AS col1, 'B' AS col2 FROM DUAL UNION ALL SELECT '1' AS col1, 'C' AS col2 FROM DUAL)SELECT col1, LTRIM (SYS_CONNECT_BY_PATH (col2, ','), ',') AS col1 FROM (SELECT col1, col2, ROW_NUMBER () OVE..
LOCK 문제를 일으키는 SQL 명령 찾기
LOCK 문제를 일으키는 SQL 명령 찾기 ---------------------------------- * 다음 Query는 Lock과 관련된 트랜잭션을 출력해준다. column username format a10 column sid format 999 column lock_type format a15 column MODE_HELD format a11 column MODE_REQUESTED format a10 column LOCK_ID1 format a8 column LOCK_ID2 format a8 select a.sid, decode(a.type, 'MR', 'Media Recovery', 'RT', 'Redo Thread', 'UN', 'User Name', 'TX', 'Transaction', ..