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