PL/SQL Update View

Update View syntax

UPDATE view_name SET col_name WHERE condition;
COURSE_IDNAMEDESCRIPTIONDURATIONPRICE
2SQL 2SQL course for advanced2 week50
4PHPPHP course4 week75
5CSSLearn CSS2 week20
100PythonPython course4 week80

Update View example

update course_view 
set price=89 
where course_id=100;
commit;
select * from course_view;

Output:

COURSE_IDNAMEDESCRIPTIONDURATIONPRICE
2SQL 2SQL course for advanced2 week50
4PHPPHP course4 week75
5CSSLearn CSS2 week20
100PythonPython course4 week89