Oracle Database - View

Card Puncher Data Processing


View in Oracle.


Which columns are updatable through a view

CREATE VIEW locations_view AS
   SELECT d.department_id, d.department_name, l.location_id,
   FROM departments d, locations l
   WHERE d.location_id = l.location_id;
SELECT column_name, updatable 
   FROM user_updatable_columns
   WHERE table_name = 'LOCATIONS_VIEW';

The primary key index on the location_id column of the locations table is not unique in the locations_view view. Therefore, locations is not a key-preserved table and columns from that base table are not updatable.

COLUMN_NAME                    UPD
------------------------------ ---
DEPARTMENT_ID                  YES
DEPARTMENT_NAME                YES
LOCATION_ID                    NO
CITY                           NO

Documentation / Reference

Discover More
Card Puncher Data Processing
Oracle Database - Data Load

Data loading in a Oracle Database environment. In the Oracle Database, you can load data in the following elements: Table, View , Materialized View, External Table Oracle Version Utility...
Card Puncher Data Processing
Oracle Database - Insert Statement

in Oracle Insert into a table or a view and as a view is based on table, insert inserts data into tables. All datatype and constraint must be honoured. See Multitable...
Card Puncher Data Processing
Oracle Database - Objects

Database object. Each database object is considered to either be: a schema object (ie owned by a user) or a “non-schema object”. See for plsql object type: Object in different namespace are...

Share this page:
Follow us:
Task Runner