top of page

Oracle

Public·1 member

Bhanu Uday
Codersarts Employee

Codersarts Team

Java Developer

UPDATE statement in Oracle-Update row data

In Oracle, UPDATE statement is used to update the existing records in a table.

Syntax:

UPDATE table 
SET column1 = expression1,  
column2 = expression2,  
 ...  
column_n = expression_n  
WHERE conditions;  

Example:

UPDATE students  
SET sname = 'Rosy' 
WHERE student_id = 2102;  

Here , sname 0f Student_id = 2102 is changed to "Rosy".


Thanks For reading. Comment down if you have any Query.



5 Views
bottom of page