PL/SQL Delete View

Delete View syntax

DELETE FROM view_name WHERE condition;
COURSE_IDNAMEDESCRIPTIONDURATIONPRICE
2SQL 2SQL course for advanced2 week50
4PHPPHP course4 week75
5CSSLearn CSS2 week20
100PythonPython course4 week89

Delete View example

delete from course_view where course_id=100;
commit;
select * from course_view;

Output:

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