USING UPDATE

This can be used to modify the table data.

Syntax:

     Update <table_name> set <col1> = value1, <col2> = value2 where <condition>;

Ex:

     SQL> update student set marks = 500;

     If you are not specifying any condition this will update entire table.

     SQL> update student set marks = 500 where no = 2;

     SQL> update student set marks = 500, name = 'Venu' where no = 1;