Oracle views created from multiple tables cannot be inserted.

The oracle view can be created from a single table or multiple tables. The oracle view created for a single table can be added, deleted, or modified. Multi-table views cannot be directly updated by adding oracle views.

Solution: Replace the trigger. Speaking of this, everyone may know how to do it.

 
 

  
  
Create or replace trigger name
  
  
 
  
  
Instead Of Insert or update or delete
  
  
 
  
  
On View
  
  
 
  
  
For each row
  
  
 
  
  
Declare
  
  
 
  
  
Begin
  
  
 
  
  
If Inserting Then
  
  
 
  
  
Insert Into basic table 1 (t11, t12) Values (: New. f1,: New. f2 );
  
  
 
  
  
Insert Into basic table 2 (t11, t22) Values (: New. f1,: New. f3 );
  
  
 
  
  
Elsif Updating Then
  
  
 
  
  
Update basic table 1 set t11 =: New. f1, t12 =: New. f2 where t11 =: New. f1;
  
  
 
  
  
Update basic table 2 set t11 =: New. f1, t22 =: New. f3 where t11 =: New. f1;
  
  
 
  
  
Elsif Deleting then
  
  
 
  
  
Delete from basic table 1 where t11 =: Old. f1;
  
  
 
  
  
Delete from basic table 2 where t11 =: Old. f1;
 
 

Entire Process of creating Oracle Materialized View

Statement syntax for oracle time addition and subtraction

Oracle deadlock handling

Statement of Oracle paging Query

ORACLE instance creation process