Interested to Buy Any Domain ? << Click Here >> for more details...
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 do I clear the screen in sql plus?
how to create a table index in mysql? : Sql dba
What is the usage of the distinct keyword?
Explain architecture of sql server notification services?
What is scalar function?
What are the various levels of constraints?
What is the use of pl/sql table?
Define concurrency control. : Transact sql
what is a database transaction? : Sql dba
what are the differences between procedure-oriented languages and object-oriented languages? : Sql dba
How to add, remove, modify users using sql?
What is %type in pl sql?
What is pl sql in oracle?
Is mariadb nosql?
How do I run a program in pl sql?
