Tip on truncating the table.
Are you preparing for IT certification? With practice questions, study notes, interactive quizzes, tips and technical articles, uCertify PrepKits ensure that you get a solid grasp of core technical concepts to ace your certification exam in first attempt.
Tip on truncating the table.
Rating:
Use TRUNCATE command in place of the DELETE command to remove all the rows from a table. The TRUNCATE command does not require an undo space in a database, and also the COMMIT command is not necessary to make the delete permanent.
Rating:
Was this information helpful?
Other articles
- What is Flashback Query?
- What is hot backup?
- What is the listener.ora file?
- Tip on specifying the constraint.
- What is TO_CHAR (datetime) function?