Basic Oracle Concepts and Programming Question:
How To Drop an Existing View in Oracle?
Answer:
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.
DROP VIEW employee_department;
View dropped.
| Previous Question | Next Question |
| How To Create a New View in Oracle? | What Are DML Statements in Oracle? |