Ad:

Oracle Discussion Thread
Unsolved
Views: 721

Mar 2nd, 2009

query in sql

Expand Post »

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.

Similar Threads

How do you connect to a sql database using C# in C#
create a query in access from vb6 in Visual Basic 4 / 5 / 6
help with an sql statement in MS SQL
VB6 / Access DAO Add Field to Existing Table/Query in Visual Basic 4 / 5 / 6
SQL Server Help in MySQL

rambo123

Reputation Points: 10

Solved Threads: 0

Newbie Poster

Offline

2 posts
since Mar 2009

Permalink

Mar 2nd, 2009

Re: query in sql

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

Click to Expand / Collapse Quote 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

alit2002

Reputation Points: 10

Solved Threads: 3

Junior Poster in Training

Offline

52 posts
since Dec 2006

Permalink

Mar 4th, 2009

Re: query in sql

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

mir77

Reputation Points: 10

Solved Threads: 0

Newbie Poster

Offline

9 posts
since Mar 2009

Permalink

Mar 4th, 2009

Re: query in sql

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.

debasisdas

Featured Poster

Reputation Points: 665

Solved Threads: 427

Posting Genius

Offline

6,406 posts
since Feb 2007

This thread is more than three months old

No one has posted to this discussion for at least three months. Please let old threads die and do not reply to them unless you feel you have something new and valuable to contribute that absolutely must be added to make the discussion complete. Otherwise, please start a new thread in this forum instead.

Previous Thread in Oracle Forum Timeline: finding duplicate names

Next Thread in Oracle Forum Timeline: How to query for users who meet purchase goals?

DaniWeb Message

Cancel Changes

User Name
Password