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 privilege is needed for a user to create views in oracle?
what is normalisation?what are its uses?
List out the types of joins.
Assuming that you are an End User How to find that in the payment Batch some of the Invoice was Missing To pay How to find That??
What is the effect of setting the value "all_rows" for optimizer_goal parameter of the alter session command? What are the factors that affect optimizer in choosing an optimization approach?
What is meant by raw datatype?
what is the use of triggers in Java program? I mean where do we use triggers in Java programming?
Why does for update in oracle 8 cause an ora-01002 error?
Is there an oracle sql query that aggregates multiple rows into one row?
What is an oracle function?
What is merge in oracle?
how to join query for one source type is oracle another source type is sql server ?
What is the difference between view and materialized view in Oracle?
How to rename an existing table?
State the difference along with examples between Oracle 9i, Oracle 10g and Oracle 11i.