[ORACLE] Create and Drop Tables or Views
In Oracle, We hope to join different tables called EMPLOYEES and EMP_DETAILS_VIEW and create a table or view. Then, now We join tables as below: [1] Join SELECT A.FIRST_NAME,B.LAST_NAME,A.EMAIL,A.JOB_ID,B.DEPARTMENT_NAME,B.MANAGER_ID FROM EMPLOYEES A JOIN EMP_DETAILS_VIEW B ON A.EMPLOYEE_ID=B.EMPLOYEE_ID; [2] Create Table CREATE TABLE TEMP_TABLE AS SELECT A.COLUME1, B.COLUME2, A.COLUME3, A.COLUM..
2019. 9. 18.
[Oracle] How to kill a locked user's session
-- 01. Check the locked table SELECT do.object_name, do.owner, do.object_type, do.owner, vo.xidusn, vo.session_id, vo.locked_mode FROM v$locked_object vo , dba_objects do WHERE vo.object_id = do.object_id ; -- 02. Find out which table is locked SELECT A.SID, A.SERIAL#, B.TYPE, C.OBJECT_NAME FROM V$SESSION A, V$LOCK B, DBA_OBJECTS C WHERE A.SID=B.SID AND B.ID1=C.OBJECT_ID AND B.TYPE='TM' AND C.OB..
2019. 8. 24.
