Oracle/SQL Fundamentals I

10일차 # 8-21: TRUNCATE Statement

Bohemian life 2012. 4. 17. 21:46

        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)


저작자표시 비영리 (새창열림)