Collections:
Delete Multiple Rows from a Table in Oracle
How To Delete Multiple Rows from a Table in Oracle?
✍: FYIcenter.com
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
⇐ Delete an Existing Row from a Table in Oracle
2020-01-04, 1795🔥, 0💬
Popular Posts:
Where to find MySQL database server tutorials? Here is a collection of tutorials, tips and FAQs for ...
How To Verify Your PHP Installation in MySQL? PHP provides two execution interfaces: Command Line In...
How To Generate CREATE TABLE Script on an Existing Table in SQL Server? If you want to know how an e...
How To Update Multiple Rows with One UPDATE Statement in SQL Server? If the WHERE clause in an UPDAT...
Where to find answers to frequently asked questions on Transaction Management: Commit or Rollback in...