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, 1809🔥, 0💬
Popular Posts:
How To Convert Numeric Expression Data Types using the CONVERT() Function in SQL Server Transact-SQL...
What Are Bitwise Operations in SQL Server Transact-SQL? Bitwise operations are binary operations per...
How To Drop a Stored Procedure in Oracle? If there is an existing stored procedure and you don't wan...
How To Find Out What Privileges a User Currently Has in Oracle? Privileges granted to users are list...
How To Get the Definition of a User Defined Function Back in SQL Server Transact-SQL? If you want ge...