Differentiate between TRUNCATE and DELETE?
Answers were Sorted based on User's Feedback
Answer / vikas
When we use truncate data deletes permanently and can not recover.Truncate is fast because it not writes any thing in log file while perform deleting operations.
Delete is used to removed table data and it can be recover by using rollback . Delete is slow because it create log file before performing the delete operation.
Is This Answer Correct ? | 0 Yes | 0 No |
Answer / vikas
delete is slow because it creates log file while performing delete operations.We can recover data which is removed by using delete command by using rollback.
Truncate is fast because it does not create any log file while performing delete operation.We can not recover data which is removed by using truncate command.
Is This Answer Correct ? | 0 Yes | 0 No |
How to use fetch statement in a loop?
Can a formula column referred to columns in higher group ?
select trunc(round(156.00,-1),-1) from dual;
How to drop a stored function?
How to load excel data sheet to oracle database
What is Public Database Link ?
What is save point in oracle database?
What are the four Oracle system processes that must always be up and running for the database to be useable?
What is an Oracle Instance?
How to define an oracle cursor variable?
Is primary key = unique key,not null? If yes,please explain IF No,please explain
What do the 9i dbms_standard.sql_txt() and dbms_standard.sql_text() procedures do?