Answer / shilpa

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

Answer / debi

1.when we use delete command then the records from the
table is not deleted permanently so that when we further
use rollback command the records are again available in the
table but in case of truncate the data is permenently
deleted from the table.
2.in case of truncate data deletion is faster as compared
to delete
3.
we can't use ant where condition in case if truncate

Answer / raam

Delete command will remove the data values ( all the
records of table) and space and table structure will be
ramain. We cannot free the space and remove the table
structure using Delete command.
Truncate command will free the memory and removes table
structure from data dictionary.

ramumcato@yahoo.com

Answer / sanjay keserwani

we can go upto some number of records through delete while
in truncate we have to unoccupied all records.

Answer / amol

Be very careful when deleting records. You cannot undo this
statement! but in mysql...

Explain the the delete statements in sql?

0 Answers  

What does sign mean sql?

0 Answers  

what does the t-sql command ident_current does? : Transact sql

0 Answers  

What is schema in sql example?

0 Answers  

How collections are improve the performance?

1 Answers   Polaris,

What are crud methods?

0 Answers  

Given two tables Student(SID, Name, Course) and Level(SID, level) write the SQL statement to get the name and SID of the student who are taking course = 3 and at freshman level.

9 Answers   Oracle,

How to display the records between two range in Oracle SQL Plus?

0 Answers   MCN Solutions,

What is pls_integer in pl sql?

0 Answers  

What is sql prepared statement?

0 Answers  

What are field types?

0 Answers  

what is global variable in pl/sql

1 Answers