SELECT *FROM DEPT_INFOWHERE CONNECT_BY_ISLEAF = 1 AND CONNECT_BY_ISCYCLE = 0START WITH PARNTS_DEPT_CD = '00000000'CONNECT BY NOCYCLE PRIOR DEPT_CD = PARNTS_DEPT_CD;

UPDATE TABLE1 T1 SET (NAME, DESC) = ( SELECT T2.NAME, T2.DESC FROM TABLE2 T2 WHERE T1.ID = T2.ID )WHERE EXISTS ( SELECT 1 FROM TABLE2 T2 WHERE T1.ID = T2.ID );

1. 테이블 목록조회SELECT *FROM all_all_tables; SELECT *FROM dba_tables; SELECT *FROM ALL_OBJECTSWHERE OBJECT_TYPE = 'TABLE' -- 접속한 계정의 테이블 목록보기SELECT *FROM tabs; SELECT *FROM USER_OBJECTS WHERE OBJECT_TYPE = 'TABLE'; SELECT *FROM USER_TABLES; -- 테이블 코멘트 보기SELECT *FROM ALL_TAB_COMMENTSWHERE TABLE_NAME = '테이블명' SELECT *FROM USER_TAB_COMMENTS; 2. 컬럼 목록조회SELECT *FROM COLS;WHERE TABLE_NAME = '테이블명'; SELECT ..

ORA-01940: 현재 접속되어 있는 사용자는 삭제할 수 없습니다 사용자 확인 select sid,serial#,username,status from v$session where schemaname = '사용자아이디(대문자)'; 프로세스 죽이기 alter system kill session 'sid,serial#';