diff between DELETE and TRUNCATE?.

Answer Posted / ron

To add to ans#1. truncate needs drop table level priviledges.

Is This Answer Correct ?    3 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How to update values on multiple rows in oracle?

581


Explain an exception and its types?

586


How to use attributes of the implicit cursor in oracle?

533


What view(s) do you use to associate a users SQLPLUS session with his o/s process?

1882


What are the differences between lov and list item?

537






How to create a table interactively?

532


What is meant by an index?

587


How to pass parameters to procedures in oracle?

547


Why do we use bulk collect in oracle?

544


How to use regular expression in pattern match conditions in oracle?

558


various types of hints and their usage

2110


What privilege is needed for a user to delete rows from tables in another schema?

547


what is reindexing?

1150


What is the difference between truncate & delete command?

589


An automatic job running via DBMS_JOB has failedKnowing only that its failed, how do you approach troubleshooting this issue?

1589