Deleting Rows
The Object Browser in the Application Express interface for Oracle Database Express edition allows you to remove rows very easily. However, each row is removed individually. To remove multiple rows with a single DELETE statement, you can use the SQL Command interface.
Some employees have left the company in the current fiscal year. Sheila has to update the database and remove these users from the EMPLOYEES table. While deleting rows, she has to address constraint violations by making changes to dependent objects.
Watch Sheila delete a row from the EMPLOYEES table.
 |