Collections:
Delete an Existing Row from a Table in Oracle
How To Delete an Existing Row from a Table in Oracle?
✍: FYIcenter.com
If you want to delete an existing row from a table, you can use the DELETE statement with a WHERE clause to identify that row. Here is good sample of DELETE statements:
INSERT INTO fyi_links (url, id) VALUES ('http://www.myspace.com', 301); 1 row created. SELECT * FROM fyi_links WHERE id = 301; ID URL NOTES COUNTS CREATED ----- ------------------------ -------- ------- --------- 301 http://www.myspace.com NULL NULL 07-MAY-06 DELETE FROM fyi_links WHERE id = 301; 1 row deleted. SELECT * FROM fyi_links WHERE id = 301; no rows selected
2020-01-04, 772👍, 0💬
Popular Posts:
How to connect SQL Server Management Studio Express to SQL Server 2005 Express in SQL Server? Once y...
How To Define an External Table in a Text File in Oracle? You can use the CREATE TABLE statement to ...
What Is ISAM in MySQL? ISAM (Indexed Sequential Access Method) was developed by IBM to store and ret...
What Are Bitwise Operations in SQL Server Transact-SQL? Bitwise operations are binary operations per...
What are DDL (Data Definition Language) statements for tables in SQL Server? DDL (Data Definition La...