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
what is a Nested Loop join?
how to use select statement as formal parameter in procedure specification?(someone said that using string) ex:-procedure(a in number,select ename from emp ) i am asking syntax like this?
What is the difference between sharding and partitioning?
What is the parameter mode that can be passed to a procedure?
What is oracle in java?
What is the difference between substr and instr?
In not less than 100 words what's the main difference between Rolap and Molap in ORACLE ?
Can the query output be sorted by multiple columns in oracle?
What is backup in Oracle?
Explain view?
How to check the oracle tns settings?
What happens if you set the sga too low in oracle?
How does one get the view definition of fixed views/tables?
What is a view and how is it different from a table?
Explain how you would restore a database using RMAN to Point in Time?
