we can go upto some number of records through delete while in truncate we

What is the difference between DELETE and TRUNCATE?

Question Posted / sanjay keserwani

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

Please Help Members By Posting Answers For Below Questions

What is java sql connection?

963

What is the difference between functions, procedures, and packages in pl/sql?

973

What do you mean by “trigger” in sql?

1015

What is set serveroutput on?

1086

What are different types of triggers?

1021

How many clustered indexes can you have?

924

Why do we use procedures in sql?

1016

What is the difference between view and stored procedure?

909

What is faster join or subquery?

957

What are different types of tables in sql?

939

What is %rowtype in pl sql?

921

What is varchar used for?

1019

Can you selectively load only those records that you need? : aql loader

983

Can a table contain multiple foreign key’s?

945

what's the difference between a primary key and a unique key? : Sql dba

970