Collections:
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
2020-02-07, 1206👍, 0💬
Popular Posts:
How To Run SQL Commands in SQL*Plus in Oracle? If you want to run a SQL command in SQL*Plus, you nee...
How To List All User Names in a Database in SQL Server? If you want to see a list of all user names ...
Where to find answers to frequently asked questions on Using INSERT, UPDATE and DELETE Statements in...
How To Change the Name of a Database User in SQL Server? If you want to change the name of an existi...
How To Define an External Table in a Text File in Oracle? You can use the CREATE TABLE statement to ...