05_01_-处理数据素材.ppt

Oracle Database 11g: SQL Fundamentals I 9 - * Oracle Database 11g: SQL Fundamentals I 9 - * Removing a Row from a Table The Contracting department has been removed from the DEPARTMENTS table (assuming no constraints on the DEPARTMENTS table are violated), as shown by the graphic in the slide. Oracle Database 11g: SQL Fundamentals I 9 - * DELETE Statement Syntax You can remove existing rows from a table by using the DELETE statement. In the syntax: table is the name of the table condition identifies the rows to be deleted, and is composed of column names, expressions, constants, subq