# CTE Resource Center - Verso - Database Design and Management (Oracle) Task 1685818599

CTE Resource Center - Verso

Virginia’s CTE Resource Center

Manipulate tables, using the INSERT, UPDATE, and DELETE commands through a view.

Definition

Manipulation of DML commands through a view is executed using the following rules:

1. A row may not be removed if the view contains

  • group functions
  • a GROUP BY clause
  • the DISTINCT keyword
  • the pseudocolumn ROWNUM keyword.

2. Data may not be modified in a view if it contains

  • group functions
  • a GROUP BY clause
  • the DISTINCT keyword
  • the pseudocolumn ROWNUM keyword
  • columns defined by expressions.

3. Data may not be added through a view if the view includes

  • group functions
  • a GROUP BY clause
  • the DISTINCT keyword
  • the pseudocolumn ROWNUM keyword
  • columns defined by expressions
  • NOT NULL columns in the base tables that are not selected by the view.

Related Standards of Learning

Mathematics

COM.7

The student will select and call library functions to process data, as appropriate.