Collections:
Update Values in a Table in Oracle
How To Update Values in a Table in Oracle?
✍: FYIcenter.com
If you want to update some values in one row or multiple rows in a table, you can use the UPDATE statement. The script below shows a good example:
UPDATE fyi_links SET counts = 999, notes = 'Good site.' WHERE id = 101; 1 row updated. SELECT * FROM fyi_links WHERE id = 101; ID URL NOTES COUNTS CREATED ---- ------------------------ ---------- ------ --------- 101 http://dev.fyicenter.com Good site. 999 07-MAY-06
⇒ Update Values on Multiple Rows in Oracle
⇐ Insert Multiple Rows with 1 INSERT Statement in Oracle
2020-01-21, 1350🔥, 0💬
Popular Posts:
How To Turn on mysql Extension on the PHP Engine in MySQL? The "mysql" API extension is provided as ...
How to download and install Microsoft .NET Framework Version 2.0 in SQL Server? .NET Framework Versi...
How to execute statements in loops in SQL Server Transact-SQL? How to use WHILE ... loops? You can u...
Where to find Oracle database server tutorials? Here is a collection of tutorials, tips and FAQs for...
How To Get a List of All Tables with "sys.tables" View in SQL Server? If you want to see the table y...