【文件属性】：
文件名称：DELETE语句-SQL语言基础
文件大小：5.26MB
文件格式：PPT
更新时间：2021-04-25 19:38:26
SQL 基础
DELETE语句
*
DELETE [FROM] table
[WHERE condition];
可以使用 DELETE 语句从表中删去现存的行.
*
Deleting Rows
You can remove existing rows by using the DELETE statement.
In the syntax:
table is the table name
condition identifies the rows to be deleted and is composed of column names, expressions, constants, subqueries, and comparison operators
For more information, see Oracle Server SQL Reference, Release 8, “DELETE.”
Instructor Note
The DELETE statement does not ask for confirmation. However, the delete operation is not made permanent until the data transaction is committed. Therefore, you can undo the operation with the ROLLBACK statement if you make a mistake.