PL/SQL Replace View

Replace View syntax

CREATE OR REPLACE VIEW view_name 
  AS 
SELECT * FROM table_name;
COURSE_ID NAME DESCRIPTION DURATION PRICE
1 SQL 1 SQL course for beginners 1 week 10
2 SQL 2 SQL course for advanced 2 week 50
3 HTML5 Learn HTML 5 1 week 10
4 PHP PHP course 4 week 75
5 CSS Learn CSS 2 week 20

Replace View example

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

select * from course_view;

Output:

COURSE_ID NAME DESCRIPTION DURATION PRICE
2 SQL 2 SQL course for advanced 2 week 50
4 PHP PHP course 4 week 75
5 CSS Learn CSS 2 week 20