How to update data in oracle
update command is use to update record in oracle, we can update single data at a time and we can update all data at a time.
When we want to update few data then we have to write where clause along with update command.
When we want to update whole record then we no need to write where condition in oracle.
Update single record
>update table_name set column-name = new_value where column_name = old_value;
>update student set name = 'Kapil' where roll = 101;
Please above example i wrote where condition because i want to update only one name record.
Update all record
>update table_name set column-name=new_value;
>update student set name = 'Vicky';
Here all name field will be updated with name Vicky.