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
How to update values on multiple rows in oracle?
Explain an exception and its types?
How to use attributes of the implicit cursor in oracle?
What view(s) do you use to associate a users SQLPLUS session with his o/s process?
What are the differences between lov and list item?
How to create a table interactively?
What is meant by an index?
How to pass parameters to procedures in oracle?
Why do we use bulk collect in oracle?
How to use regular expression in pattern match conditions in oracle?
various types of hints and their usage
What privilege is needed for a user to delete rows from tables in another schema?
what is reindexing?
What is the difference between truncate & delete command?
An automatic job running via DBMS_JOB has failedKnowing only that its failed, how do you approach troubleshooting this issue?