# CTE Resource Center - Verso - Database Design and Management (Oracle) Task 1685818576

CTE Resource Center - Verso

Virginia’s CTE Resource Center

Delete rows in a table.

Definition

Deletion should include using the following syntax:

DELETE FROM [table name]
WHERE clause

In addition, omitting the WHERE clause will delete all rows in a table. The INSERT, UPDATE, and DELETE commands are part of the DML. This group of commands is not automatically committed to the database and stays in the buffer until a COMMIT occurs. A COMMIT can occur by

  • typing a DML (or autocommit command)
  • typing the keyword COMMIT
  • gracefully exiting the database by typing the word EXIT
  • selecting auto commit in Application Express.

If an unwanted delete is made, the keyword ROLLBACK can be typed and the buffer will be cleared of any commands it contains.

Related Standards of Learning

Mathematics

COM.14

The student will select and implement appropriate data structures, including arrays (one- and/or two-dimensional) and objects.

Other Related Standards

Microsoft Imagine Academy Resources

[3.170] SQL Server 2008 Release 2: Modifying Data in Tables with Microsoft SQL Server 2008—E-Learning Module 6

[4.019] Access 2010: Modify Database Tables—Lesson 3

[5.035] Access 2010: Project 3

NBEA Achievement Standards for Information Technology

Enter data and edit fields and records.