Showing posts with label How to update a row of a table?. Show all posts
Showing posts with label How to update a row of a table?. Show all posts

Wednesday, September 2, 2009

How to update a table in oracle?

Oracle query for Update all the rows in a table:

Syntax:
UPDATE tablename SET fieldname='value'

Query:

UPDATE STUDENT SET CLASS = 'IV'

You can update a single row by using the where condition. The query is as fallows


UPDATE STUDENT SET CLASS = 'IV' WHERE STUDENT_ID = 100;