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, 4149🔥, 0💬
Popular Posts:
How to download Microsoft SQL Server 2005 Express Edition in SQL Server? Microsoft SQL Server 2005 E...
What Happens to the Current Transaction If a DDL Statement Is Executed in Oracle? If a DDL statement...
How To Revise and Re-Run the Last SQL Command in Oracle? If executed a long SQL statement, found a m...
How AdventureWorksLT tables are related in SQL Server? There are 12 user tables defined in Adventure...
Is PL/SQL Language Case Sensitive in Oracle? PL/SQL language is not case sensitive: Reserved words a...