Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference between DELETE and TRUNCATE?
- 15 Answers
- 25143 Views
- Johns Hopkins University, Tech Mahindra, I also Faced
- E-Mail Answers
Answer Posted / sanjay keserwani
we can go upto some number of records through delete while
in truncate we have to unoccupied all records.
| Is This Answer Correct ? | 4 Yes | 7 No |
Post New Answer View All Answers
What are the differences between implicit and explicit cursors?
What is varchar used for?
How do you delete a table?
What is aggregate function in sql?
In what condition is it good to disable a trigger?
Can we insert data into materialized view?
Does execute immediate commit?
how to delete duplicate rows from a join tables(I have three tables on that join) how do you know which join is need to be used? The select statement I have is: SELECT gc_skill_type.skill_type, gc_area_tec.area, gc_technology.technology, gc_technology.id_technology, gc_area_tec.id_area_tec FROM gc_skill_type, gc_area_tec, gc_technology WHERE gc_area_tec.id_skill_type (+) = gc_skill_type.id_skill_type AND gc_technology.id_area_tec (+) = gc_area_tec.id_area_tec order by gc_skill_type.skill_type asc, gc_area_tec.area asc, gc_technology.technology asc
What is the use of pl/sql table?
What action do you have to perform before retrieving data from the next result set of a stored procedure ?
How to change a value of the field ‘salary’ as 7500 for an employee_name ‘john’ in a table employee_details?
What are the three forms of normalization?
What are the different dml commands in sql?
What is not null in sql?
What are sql indexes?
