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;