PL/SQL Insert View

Insert View syntax

INSERT INTO view_name(col_name) VALUES (col_value);
COURSE_IDNAMEDESCRIPTIONDURATIONPRICE
2SQL 2SQL course for advanced2 week50
4PHPPHP course4 week75
5CSSLearn CSS2 week20

Insert View example

insert into course_view (course_id, name, description, duration, price)
values (100, 'Python', 'Python course', '4 weeks', 80);
commit;
select * from course_view;

Output:

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