Update Values in a Table in Oracle

Q

How To Update Values in a Table in Oracle?

✍: FYIcenter.com

A

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

 

Understanding SQL DML Statements for Oracle

⇒⇒Oracle Database Tutorials

2016-10-16, 139👍, 0💬