Basic Oracle Concepts and Programming Question:

Download Job Interview Questions and Answers PDF

How To Drop an Existing View in Oracle?

Oracle Database Interview Question
Oracle Database Interview Question

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.


Download Oracle Database Interview Questions And Answers PDF

Previous QuestionNext Question
How To Create a New View in Oracle?What Are DML Statements in Oracle?