SQL语言基础中的DELETE语句

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.