PL/SQL Replace View

Replace View syntax

CREATE OR REPLACE 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

Replace View example

create or replace view course_view 
  as
select * from course 
where price > 10;
select * from course_view;

Output:

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