PL/SQL Drop View

Drop View syntax

DROP VIEW view_name;
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

Drop View example

DROP VIEW test_view;

select * from test_view;

Output:

ORA-00942: table or view does not exist