Categories:
.NET (357)
C (330)
C++ (183)
CSS (84)
DBA (2)
General (7)
HTML (4)
Java (574)
JavaScript (106)
JSP (66)
Oracle (114)
Perl (46)
Perl (1)
PHP (1)
PL/SQL (1)
RSS (51)
Software QA (13)
SQL Server (1)
Windows (1)
XHTML (173)
Other Resources:
How To Delete Multiple Rows from a Table
How To Delete Multiple Rows from a Table? - Oracle DBA FAQ - Understanding SQL DML Statements
✍: 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
2007-04-21, 5946👍, 0💬
Popular Posts:
How does one iterate through items and records in a specified block? One can use NEXT_FIELD to itera...
Can Sub Procedure/Function Be Called Recursively? - Oracle DBA FAQ - Creating Your Own PL/SQL Proced...
What Is a TD Tag/Element? - XHTML 1.0 Tutorials - Understanding Tables and Table Cells A "td" elemen...
What is the concept of XPOINTER? XPOINTER is used to locate data within XML document. XPOINTER can p...
Can you explain in brief how the ASP.NET authentication process works? ASP.NET does not run by itsel...