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