diff between DELETE and TRUNCATE?.

Answer Posted / chaitanyabilla

delete-low water mark level
truncate-high water level

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How to set a transaction to be read only in oracle?

573


Can you assign multiple query result rows to a variable?

543


How to view all columns in an existing table?

543


What is the maximum limit on the number of columns in a table?

545


why should i declare foreign key constraint as self relation instead of binary relation in tables ?

1561






What is the difference between a user and a schema in oracle?

554


Explain the features of oracle?

588


What is a partition in oracle?

538


What is a proxy class?

549


How can you tell how much space is left on a given file system and how much space each of the file systems subdirectories take-up?

2387


What is a select query statement in oracle?

539


Are truncate and delete commands same? If so why?

644


How to invoke the original export import utilities?

499


How to list all user accounts in oracle?

603


How to find out what oracle odbc drivers are installed?

561