oracle - 物化视图

  create or replace view ov_applicant of ob_applicant with object oid (applicantid) as select * from applicant;--ov_applicant完全等同applicant

  insert into ov_applicant values g_ob_applicantinfo;

--将g_ob_applicantinfo（即ob自定义类型object）里面的数据插入到ov_applicant中，applicant表里面就有数据了，

避免了，insert into tablenames('','',',',',','') values('','',',',','',) 这种很繁琐的写法，特别是对字段很多的大表字段，上百个的

 

更改：update ov_policy policy set policy = g_ob_policy where policy.policyid = g_ob_policy.policyid;