Delete command delets one row or whole table with table defination but tr

What is the difference between DELETE and TRUNCATE?

Question Posted / shilpa

Answer Posted / shilpa

Delete command delets one row or whole table with table
defination but truncate command only delete table not table
defination

Is This Answer Correct ?

2 Yes

1 No

Please Help Members By Posting Answers For Below Questions

What is the difference between function, procedure and package in pl/sql?

561

Which sql most popular?

556

Why is sql*loader direct path so fast?

601

What is triggering circuit?

597

How many subqueries can be nested in a statement?

505

Is a view faster than a stored procedure?

548

What is a sql driver?

530

What is data control language?

532

how to do backup entire database? : Transact sql

618

Can you have a foreign key without a primary key?

510

What is the difference between left and left outer join?

518

Is it possible to Restore a Dropped Table using Rollback Command in Oracle SQL Plus ?

722

How many primary keys can a table have?

534

What is the purpose of normalization?

537

How to convert comma separated string to array in pl/sql?

600