Simply to say -
DML statements (Delete) can be rollbacked where DDL (Truncate) are autocommit.
Re: difference between delete and truncate
Simply to say -
DML statements (Delete) can be rollbacked where DDL (Truncate) are autocommit.
Sanghala
If you are satisfied with my reply. Please click “Thanks” button which increases the reputation and can serve you better.
'truncate' requires no condition bcoz it deletes the total table once where as 'delete' requires condition bcoz it deletes the data row by row.....
Posting Permissions
Reply With Quote