Answer Posted / kiran.
Delete(DML) : All records not possible to Delete at a time,
Where clause is allowed.
structure of the table is available.
Roll Back is possible.
Truncate(DDL): All records possible to Delete at a time,
Where clause is not allowed.
structure of the table is not available.
Roll Back is possible.
>Truncate Table<tablename>;
| Is This Answer Correct ? | 0 Yes | 3 No |
Post New Answer View All Answers
How to avoid using cursors?
What is bulk collect in pl sql?
What is sql injection owasp?
What are the different parts of a package?
Explain the methods used to protect source code of pl/sql.
What is the difference between an inner join and an outer join?
What is sqlexception in java?
What is 19 null in sql?
What is sql analyzer?
What are the types of views in sql?
what are the advantages a stored procedure? : Sql dba
What is data profiling in sql?
What is a dirty read sql?
who introduced sql?
How do I view output in sql developer?