How To Update Values in a Table

Q

How To Update Values in a Table? - Oracle DBA FAQ - Understanding SQL DML Statements

✍: 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

2007-04-21, 4308👍, 0💬