You can perform DML operations on data through a simple view
You cannot remove a row from a view if the view contains the following:
• Group functions
• A GROUP BY clause
• The DISTINCT keyword
• The pseudocolumn ROWNUM keyword
• The columns defined by expressions
• The NOT NULL columns in the base tables that are not selected by the view