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
2020-01-04, 891👍, 0💬
Popular Posts:
How to download and install the scaled-down database AdventureWorksLT in SQL Server? If you want to ...
How To Download Oracle Database 10g XE in Oracle? If you want to download a copy of Oracle Database ...
How To Format DATETIME Values to Strings with the CONVERT() Function in SQL Server Transact-SQL? SQL...
How To Get the Definition of a User Defined Function Back in SQL Server Transact-SQL? If you want ge...
How to download and install SQL Server 2005 Sample Scripts in SQL Server? If you want to learn from ...