Whenever we are using "delete from tablename" or by using "truncate table tablename" then all rows are deleted from a table. Whenever we are using delete command then automatically deleted data internally stored in a buffer. We can also get it back this deleted rows from buffer by using rollback command,(without using commit). Whenever we are using truncate command then all rows are permanently deleted from a table. That's why we cannot get it back this deleted rows by using rollback also.
No comments:
Post a Comment