we can utilise the space for record which is uesd to truncate but delete

What is difference between TRUNCATE & DELETE?

Question Posted / rao

Answer Posted / rao

we can utilise the space for record which is uesd to
truncate but delete we cant use same same space.

Is This Answer Correct ?

8 Yes

2 No

Please Help Members By Posting Answers For Below Questions

How to Execute a Package in PL/SQL.?

570

How do you rank data in sql?

507

how would you write a query to select all teams that won either 2, 4, 6 or 8 games? : Sql dba

762

What are packages in pl sql and also explain its advantages?

520

how to check myisam tables for errors? : Sql dba

583

How do you modify a column in sql?

520

How would you reference column values before and after you have inserted and deleted triggers?

616

What do you mean by query optimization?

539

Is sql an operating system?

533

How to run sql commands in sql*plus?

574

Can unique keys be null?

474

Compare sql & pl/sql

598

Can we call dml statement in function?

531

Can you rollback after commit?

515

does sql support programming? : Sql dba

600