what is the difference between TRUNCATE and DELETE command
in SQL

Answer Posted / nithya

The delete statement will result in the table spaces or
memories would remain as the current size and table
structure remain in the database. Delete is not effective
when you use it to remove all data from a table, because it
takes up storage spaces due to unclear memories.

The truncate statement will result in clearing table spaces
or memories and the table structure remain in the database.
Therefore it free table storage spaces and use it only when
you need to remove all data from a table.

Is This Answer Correct ?    24 Yes 3 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

which gives Oracle R12 Financial training in delhi please give me answer its urgent?

1896


Can we modify approve purchase order?if yes what is navigation?

1524


What is the use of transaction flexfield in autoinvoice? : oracle accounts receivable

663


What is the difference between recovery and restoring of the oracle database?

640


we have 10 concurrent programs under one request group out of 10 ccps all users submitting only 9 programs from srs window remaining one ccp for specific user how can it possible send me answer asap.

1851






What is the difference between oracle media recovery and crash recovery?

651


What are the advantages of operating a database in ARCHIVELOG mode over operating it in NO ARCHIVELOG mode in Oracle?

624


can u give guidance abt packages of plsql

1624


What is an Oracle database Full Backup?

606


What is the disk migration? what is the steps involved in oracle disk migration?

688


What is autocashrule set? : oracle accounts receivable

690


1)After defining value set we define list of values, I need to enter 1000 values with out entering manually, how will you do that? 2)what are the parameters we use in a concurrent program? 3)what is payroll processing? 4)In organization window after defining an organization and organization classification how to create a new item in the others button? 5)If there are 10 users, How to restrict the selected users not to access the forms?

1620


How many segment are present in Oracle Manufacturing

1786


How would you determine what sessions are connected and what resources they are waiting for?

1587


What are the standard concurent programs for auto invoice interface and customer interfaces? : oracle accounts receivable

603