how to update data in oracle


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;

Example

>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;

Example

>update student set name = 'Vicky';

Here all name field will be updated with name Vicky.






Full-stack web and mobile app development company Contact Us : Skype: indore.webcoder Email: info@w3sparks.com Sales: +91 8085506229