Truncate will remove the watermark from the table, but the delete will no

What is the difference between DELETE and TRUNCATE?

Question Posted / gourvendra singh

Answer Posted / gourvendra singh

Truncate will remove the watermark from the table, but the
delete will not.

Is This Answer Correct ?

6 Yes

4 No

Please Help Members By Posting Answers For Below Questions

Can one improve the performance of sql*loader? : aql loader

579

Is it possible to remove child records without removing master table records...the two having pk,fk relationship?

802

What is difference between sql and oracle?

553

Can a trigger call a stored procedure?

530

What is the starting oracle error number?

558

What do you mean by rowid?

532

What is java sql package?

525

how to select first 5 records from a table? : Sql dba

501

What is sql used for?

636

What is sql*loader?

563

What is sql injection owasp?

540

Does truncate free space?

510

Does a primary key have to be a number?

512

Does execute immediate commit?

684

Explain scalar functions in sql?

571