What is the difference between DELETE and TRUNCATE?
Answer Posted / althaf
the delete command log all the stmts in the transaction log
and the truncate command dont log the stmts.
Is This Answer Correct ? | 8 Yes | 2 No |
Post New Answer View All Answers
What is pl sql record in oracle?
what is the difference between mysql_fetch_object and mysql_fetch_array? : Sql dba
what is a foreign key ? : Sql dba
What are pl/sql packages?
Does mysql_real_escape_string prevent sql injection?
Can there be more than one function with a similar name in a pl/sql block?
Why plvtab is considered as the easiest way to access the pl/sql table?
What is faster join or subquery?
column A column b | output 10 7 | 10 5 8 | 8 7 -9 | 7 3 5 | 5 0 6 | 6 Write a sql query to print such output.
What is sorting in sql?
What is mdb stand for?
Can I copy :old and :new pseudo-records in/to an oracle stored procedure?
How to add a column ‘salary’ to a table employee_details?
Is sql scripting language?
Does sql between include endpoints?