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
2016-10-17, 578👍, 0💬
Related Topics:
