Shulou(Shulou.com)06/01 Report--

This article will explain in detail what are the methods for deleting table data from oracle. Xiaobian thinks it is quite practical, so share it with you for reference. I hope you can gain something after reading this article.

How to delete table data

Two ways to delete table contents

1. Name of truncate table;

delete from table name where condition;

Differences between the two methods:

truncate, meaning truncate table, can delete all tables without occupying resources, the advantage is fast, the disadvantage is that deletion cannot be restored, and cannot be deleted according to conditions.

delete, meaning delete, this operation takes up redolog, the advantage can be quickly restored and deleted, the disadvantage is slow deletion, mass deletion is not recommended.

About oracle delete table data methods have what to share here, hope the above content can have some help to everyone, can learn more knowledge. If you think the article is good, you can share it so that more people can see it.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.