rollback1 [SQL]ROLLBACK,세션,RENAME,MODIFY,INDEX(생성,삭제),VIEW,인라인뷰(WITH절) /*01.삽입*/ INSERT INTO DEPT_TCL VALUES (50,'DATABASE','SEOUL'); /*02.수정*/ UPDATE DEPT_TCL SET LOC = 'BUSAN' WHERE DEPTNO = 40; /*03.삭제*/ DELETE FROM DEPT_TCL WHERE DNAME='RESEARCH'; COMMIT; ROLLBACK; /*P277 테이블에 있는 데이터 수정하기*/ SELECT * FROM DEPT_TEMP2; /* UPDATE SET */ UPDATE DEPT_TEMP2 SET LOC='SEOUL'; /* 수정작업을 되돌리고 싶을 때 ROLLBACK*/ ROLLBACK; /* DELETE FROM */ SELECT * FROM EMP_TEMP2; DELETE FROM .. 2020. 6. 11. 이전 1 다음