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
What are the uses of a database trigger?
1) Does oracle have any table which contain all the exceptions and it's code internally?
How to divide query output into groups in oracle?
what is the scenario where you take the database to NoArchivelog mode?
What is the difference between sharding and replication?
What is a cursor and what are the steps need to be taken?
Is it possible to set second Primary Key Constraint in a table in Oracle Database ?
Explain what are synonyms used for?
Difference between open_form and call_form in oracle.
What is Segment Advisor in Oracle?
How can you merge two tables in oracle?
Differentiate between post-database commit and post-form commit?
I just want to maintain data like an employee can belongs to 3 or more departments . We can resolve this by using composite key but it avoids normalization rules. So Can anyone tell me how can I maintain data.
How many file formats are supported to export data?
How do we get field details of a table?