Home > Database > Oracle > body text

What is the delete statement in oracle database

WBOY
Release: 2022-05-13 10:21:35
Original
20013 people have browsed it

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.

What is the delete statement in oracle database

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 列名称=值
Copy after login

Delete all rows:

Delete From 表名称      或    Delete *  From  表名
Copy after login

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

Syntax:

Drop  Table 表名称
Copy after login

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  表名称
Copy after login

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!

Related labels:
source:php.cn
Statement of this Website
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Popular Tutorials
More>
Latest Downloads
More>
Web Effects
Website Source Code
Website Materials
Front End Template