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, 1359🔥, 0💬
Popular Posts:
What Is the Difference Between GETDATE() and GETUTCDATE() in SQL Server Transact-SQL? The difference...
How To Use GO Command in "sqlcmd" in SQL Server? "sqlcmd" is a command line client application to ru...
How To Install PHP on Windows in MySQL? The best way to download and install PHP on Windows systems ...
How To Generate Random Numbers with the RAND() Function in SQL Server Transact-SQL? Random numbers a...
What is test testing area for? The testing area is provided to allow visitors to post testing commen...