Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference between DELETE and TRUNCATE?
- 15 Answers
- 24491 Views
- Johns Hopkins University, Tech Mahindra, I also Faced
- E-Mail Answers
Answer Posted / anitha
If we are using the delete command means the content of the
table will be deleted.but we can recover that data by using
the roll back query in my sql.
But this one is not possible we can use truncate.so some
times of our carelessness we can loss some valuable and
sensitive datas.
so make sure of that before using truncate...
| Is This Answer Correct ? | 3 Yes | 1 No |
Post New Answer View All Answers
What is foreign key and example?
When are we going to use truncate and delete?
1. is it possible to use the cursor atttibutes (%found ,% rowcount , %isopen , %notfound ) to our user defined cursor names ....... cursor cursor_name is select * from scott.emp if you use... cursor_name%found , %rowcount ,%isopen,%notfound...will it work... -------------------------- 2.what is the difference between the varray and index by table .. -------- 3. type type_name is table of number(8,3) index by binary_integer; identifier_name type_name; first , last , prior , next ,trim are the methods we can use it for the above type...simillary is there any way to apply for cursors... with thanks and regards..sarao...
What is the maximum rows in csv?
Is primary key always clustered index?
What is a behavioral trigger?
Is it possible to pass parameters to triggers?
What is a composite primary key?
what is sql in mysql? : Sql dba
How do you drop a trigger?
Define a temp table?
What are types of indexes in sql?
How do you declare a constant?
What is constant in pl sql?
What are joins in sql?
