Skip to content

Oracle PL/SQL Tutorial

Learn Oracle SQL

  • Home
  • Joins
    • Inner Join
    • Left Join
    • Right Join
    • Self Join
    • Full Join
  • Constraints
    • Add primary key
    • Add constraint foreign key
    • Drop constraint key
    • Enable a foreign key
    • Disable foreign key
  • Cursors
  • Triggers
  • Indexes
    • Create index oracle
    • Alter index oracle
    • Drop index oracle
    • List all indexes from Oracle database
  • Interview Questions

PL/SQL Drop View

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

Post navigation

PL/SQL Rename View
PL/SQL Insert View
  • PL/SQL Tutorial
  • PL/SQL Functions
  • PL/SQL Select Query
  • PL/SQL Table Joins
  • PL/SQL Cursors
  • PL/SQL Collections and Records
  • PL/SQL Triggers
  • PL/SQL Views
  • PL/SQL Exception Handling
  • PL/SQL Sequential Control
  • PL/SQL Iterative Control
  • PL/SQL Control Structures
  • PL/SQL Procedure
  • PL/SQL Function
  • PL/SQL Data Types
  • PL/SQL Indexes
  • PL/SQL Constraints
  • PL/SQL %ROWTYPE Attribute
  • PL/SQL %TYPE Attribute
  • PL/SQL Variables
  • PL/SQL Anonymous block
  • PL/SQL Operators
  • PL/SQL Delete
  • PL/SQL Update
  • PL/SQL Insert
  • PL/SQL Select
  • PL/SQL Create Table
  • PL/SQL Alter Table
  • PL/SQL Add Column
  • PL/SQL Modify Column
  • PL/SQL IDENTITY Column
  • PL/SQL Sequence
  • PL/SQL Dynamic SQL
  • PL/SQL CTE
  • PL/SQL REGEXP
  • PL/SQL JSON
  • PL/SQL XML
Copyright 2013 - 2023 PL/SQL Tutorial | Privacy Policy
↑