Oracle

query in sql

Please support our Oracle advertiser: PostgreSQL or MySQL? Compare and contrast the two most popular open source databases

•

Join Date: Mar 2009

Posts: 2

Reputation: rambo123 is an unknown quantity at this point

Solved Threads: 0

rambo123

Offline

Newbie Poster

query in sql

Mar 2nd, 2009

hi,

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

<URL SNIPPED>

Last edited by peter_budo; Mar 4th, 2009 at 8:25 pm. Reason: Keep It Spam-Free - Do not spam, advertise, plug your website, or engage in any other type of self promotion.

•

Join Date: Dec 2006

Posts: 44

Reputation: alit2002 is an unknown quantity at this point

Solved Threads: 1

alit2002

Offline

Light Poster

Re: query in sql

Mar 2nd, 2009

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

•

Originally Posted by rambo123

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

•

Join Date: Mar 2009

Posts: 9

Reputation: mir77 is an unknown quantity at this point

Solved Threads: 0

mir77

Offline

Newbie Poster

Re: query in sql

Mar 4th, 2009

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

•

Join Date: Feb 2007

Posts: 2,093

Reputation: debasisdas will become famous soon enough

Solved Threads: 126

debasisdas debasisdas is offline

Offline

Postaholic

Re: query in sql

Mar 4th, 2009

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.

Share your Knowledge.