Drop an Existing View in Oracle


How To Drop an Existing View in Oracle?

✍: FYIcenter.com


If you have an existing view, and you don't want it anymore, you can delete it by using the DROP VIEW statement as shown in the following script:

DROP VIEW employee_department;
View dropped.


Understanding SQL DML Statements for Oracle

Create a New View in Oracle

Understanding SQL DDL Statements for Oracle

⇑⇑ Oracle Database Tutorials

2020-02-07, 1534🔥, 0💬