We can specify a condition while using deletecommand.But Truncate is unco

What is difference between TRUNCATE & DELETE?

Question Posted / pravallika

Answer Posted / pravallika

We can specify a condition while using deletecommand.But
Truncate is unconditional

Is This Answer Correct ?

4 Yes

1 No

Please Help Members By Posting Answers For Below Questions

How will you distinguish a global variable with a local variable in pl/sql?

1153

What is difference between sql and oracle?

1127

How can a pl sql block be executed?

944

What is the use of sql trace?

952

How to start oracle sql developer?

1032

What are the different types of functions in sql?

1052

Does pl sql work in mysql?

980

What does the argument [or replace] do?

1079

Is delete faster than truncate?

1002

how can you create an empty table from an existing table? : Sql dba

1152

Is a view faster than a stored procedure?

965

What is sql not null constraint?

1035

Who developed sql?

1044

What is clause?

1147

Differentiate between sga and pga.

1161