PL/SQL Create View

Create View syntax

CREATE VIEW view_name 
  AS 
SELECT * FROM table_name;
COURSE_IDNAMEDESCRIPTIONDURATIONPRICE
1SQL 1SQL course for beginners1 week10
2SQL 2SQL course for advanced2 week50
3HTML5Learn HTML 51 week10
4PHPPHP course4 week75
5CSSLearn CSS2 week20

Create View example

create view course_view 
  as
select * 
from course 
where price > 20;
select * from course_view;

Output:

COURSE_IDNAMEDESCRIPTIONDURATIONPRICE
2SQL 2SQL course for advanced2 week50
4PHPPHP course4 week75