drop table SQLD_30_19; CREATE TABLE SQLD_30_19 (COL1 NUMBER) ; INSERT INTO SQLD_30_19 VALUES (1); INSERT INTO SQLD_30_19 VALUES (2); SAVEPOINT SV1; UPDATE SQLD_30_19 SET COL1=4 WHERE COL1=2; SAVEPOINT SV1; DELETE SQLD_30_19 WHERE COL1 >=2; ROLLBACK TO SV1; INSERT INTO SQLD_30_19 VALUES (3); SELECT MAX(COL1) FROM SQLD_30_19;
직접 돌려보세요