CREATE table my_employees
AS SELECT * from hr.employees
Table created.
alter table my_employees ADD CONSTRAINT my_employees_pk PRIMARY KEY (employee_id)
Table altered.
CREATE MATERIALIZED VIEW LOG ON my_employees
Statement processed.
CREATE MATERIALIZED VIEW employees_mv
BUILD IMMEDIATE
REFRESH FAST ON COMMIT
AS SELECT * from my_employees
Statement processed.
update my_employees set salary = 1 where email = 'SKING'
1 row(s) updated.
select
EMPLOYEE_ID,
FIRST_NAME,
LAST_NAME,
EMAIL,
SALARY
from MY_EMPLOYEES
where email = 'SKING'
EMPLOYEE_ID | FIRST_NAME | LAST_NAME | SALARY | |
---|---|---|---|---|
100 | Steven | King | SKING | 1 |
select
EMPLOYEE_ID,
FIRST_NAME,
LAST_NAME,
EMAIL,
SALARY
from EMPLOYEES_MV
where email = 'SKING'
EMPLOYEE_ID | FIRST_NAME | LAST_NAME | SALARY | |
---|---|---|---|---|
100 | Steven | King | SKING | 24000 |
commit
Statement processed.
select
EMPLOYEE_ID,
FIRST_NAME,
LAST_NAME,
EMAIL,
SALARY
from EMPLOYEES_MV
where email = 'SKING'
EMPLOYEE_ID | FIRST_NAME | LAST_NAME | SALARY | |
---|---|---|---|---|
100 | Steven | King | SKING | 1 |