query in sql

[rambo123]

hi,

what is the diffrence between delete and truncate command in sql.
plz send me tutorials of oracle also.
waiting for your reply.

[alit2002]

Delete allows you to rollback or undo your transaction. Truncate doesn't use the rollbacks and the data is gone. Truncate should be quicker than delete if you are deleting all records in a table.

Check otn.oracle.com for documentation.

Alistair

hi,

what is the diffrence between delete and truncate command in sql. plz send me tutorials of oracle also. waiting for your reply.

computer support

[mir77]

Morely delete command delete the data but not memory capture by row but truncate delete the rows and release the space captured by rows.

mir77

[debasisdas]

delete deletes the records, which can be made permanent by using COMMIT, and can't be rolled back.

Truncate deletes the rows and resets the high watermark and there by de-allocating all the space allocated to the table.