What is the delete statement in oracle database

Oracle's delete statement: 1. "Delete From table name Where column name = value", this statement is used to delete rows in the table; 2. "Drop Table table name", this statement is used to delete the table ;3. "Truncate Table table name", this statement is used to delete data in the table.

The operating environment of this tutorial: Windows 10 system, Oracle 11g version, Dell G3 computer.

What is the delete statement of oracle database?

Introduction to the database delete statement:

1. Delete: used to delete rows in the table( Note: You can delete a certain row; you can also delete all rows without deleting the table (which means that the structure, attributes, and indexes of the table are complete)

Syntax:

Delete a certain row :

Delete From 表名称 Where 列名称=值

Delete all rows:

Delete From 表名称 或 Delete * From 表名

2. Drop: Used to delete table(Note: The structure, attributes, and indexes of the table will also be deleted.)

Syntax:

Drop Table 表名称

3. Truncate: used to delete data in the table(Note: only deletes the data in the table, not the table itself, equivalent to Delete The statement is the same without writing the Where clause)

语法：Truncate Table 表名称

Recommended tutorial: "Oracle Video Tutorial"

The above is the detailed content of What is the delete statement in oracle database. For more information, please follow other related articles on the PHP Chinese website!