Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / surendra
truncate
it deletes only the records from the table
it doesn't delete the structure of the table
we cannot rollback it
we cannot delete a particular record from the table
it is ddl
drop
it deletes the records as well as structure of the table too
we cannot rollback the records
we can flashback the table from the version 9x
it is ddl
delete
it deletes the only records which are we mention in the where clause or whole records
it is dml
we can rollback it
| Is This Answer Correct ? | 3 Yes | 2 No |
Post New Answer View All Answers
Difference between hot backup vs. Cold backup?
What are the different types of partitions in oracle?
What are the restrictions in a oracle read only transaction?
Can we connect to ORACLE db using Windows Authentication?
How to view the data files in the current database?
How to open and close an explicit cursor in oracle?
Can you create a synonym without having a table?
Iam learning oracle developer 2000.. can anyone give me then tutorials sites or PDF related to developer 2000 please send me the details @ mak2786@gmail.com thanks Arun
How to use subqueries in the from clause in oracle?
What happens to the current transaction if the session is killed?
What happens internally when the user types userID/password@string in SQL PLUS Thanks-Bhaskar
How to create an oracle testing table?
How to run queries on external tables?
How to set up autotrace for a user account?
Explain the use of log option in exp command.
