Delete Multiple Rows from a Table in Oracle

Q

How To Delete Multiple Rows from a Table in Oracle?

✍: FYIcenter.com

A

You can delete multiple rows from a table in the same way as deleting a single row, except that the WHERE clause will match multiple rows. The tutorial exercise below deletes 3 rows from the fyi_links table:

SELECT * FROM fyi_links WHERE id >= 250;
   ID URL                   NOTES        COUNTS CREATED
----- --------------------- ----------- ------- ---------
 1250 Retail Sales.com      Wrong URL       500 07-MAY-06
 1260 Recruiting.com        Wrong URL       520 07-MAY-06
 1270 Payroll.com           Wrong URL       540 07-MAY-06

DELETE FROM fyi_links WHERE id >= 250;
3 row deleted.

SELECT * FROM fyi_links WHERE id >= 250;
no rows selected

 

Understanding SQL DML Statements for Oracle

⇒⇒Oracle Database Tutorials

2016-10-17, 292👍, 0💬