1) DDL, No Rollback Information
2) Does not fire delete trigger --> faster than DELETE statement
3) can NOT trucate a table if it is referenced by children table (FK constraint)
'Oracle > SQL Fundamentals I' 카테고리의 다른 글
| 10일차 # 8-26: Transaction & Read Consistency (0) | 2012.04.17 |
|---|---|
| 10일차 # 8-24: Transaction (Tx) (0) | 2012.04.17 |
| 10일차 # 8-18: DELETE Statement (0) | 2012.04.17 |
| 10일차 # 8-13: UPDATE (0) | 2012.04.17 |
| 10일차 # 8-11: 테이블 복사 & 테이블에 데이터 여러 건을 한꺼번에 입력 (0) | 2012.04.17 |