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, 2917🔥, 0💬
Popular Posts:
How To Generate Random Numbers with the RAND() Function in SQL Server Transact-SQL? Random numbers a...
How To Create a Table Index in Oracle? If you have a table with a lots of rows, and you know that on...
How to obtain the number of rows found by the last SELECT statement using the FOUND_ROWS() function?...
Where to find answers to frequently asked questions on Managing Security, Login and User in SQL Serv...
Where to find MySQL database server tutorials? Here is a collection of tutorials, tips and FAQs for ...