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;

No comments:

Post a Comment

Please comment on this