Home >> FAQs/Tutorials >> Oracle Tutorials

Oracle Tutorials - Update Values in a Table

By: FYIcenter.com

(Continued from previous topic...)

How To Update Values in a Table?

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

(Continued on next topic...)

  1. What Are DML Statements?
  2. How To Create a Testing Table?
  3. How To Set Up SQL*Plus Output Format?
  4. How To Insert a New Row into a Table?
  5. How To Specify Default Values in INSERT Statement?
  6. How To Omit Columns with Default Values in INSERT Statement?
  7. How To Insert Multiple Rows with One INSERT Statement?
  8. How To Update Values in a Table?
  9. How To Update Values on Multiple Rows?
  10. How To Use Existing Values in UPDATE Statements?
  11. How To Use Values from Other Tables in UPDATE Statements?
  12. What Happens If the UPDATE Subquery Returns Multiple Rows?
  13. How To Delete an Existing Row from a Table?
  14. How To Delete Multiple Rows from a Table?
  15. How To Delete All Rows from a Table?

Oracle Tutorials:


Other Tutorials/FAQs:


Related Resources:


Selected Jobs: