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 download oracle database 10g xe?
What is the difference between $oracle_base and $oracle_home?
Explain the use of grant option in exp command.
How do you get nicely formatted results from an oracle procedure that returns a reference cursor?
How to see free space of each tablespace?
What is proxy method?
What view(s) do you use to associate a users SQLPLUS session with his o/s process?
Can we store pictures in the database and if so, how it can be done?
Can a formula column be obtained through a select statement ?
What is format trigger?
Will you be able to store pictures in the database?explain.
Explain oracle’s system global area (sga).
How to define a record variable to store a table row?
Explain oracle instance.
How to insert a record into a table?