Oracle-Materialized View

Create or replace view ov_applicant of ob_applicant with object OID (applicantid) as select * from applicant; -- ov_applicant is equivalent to applicant.

Insert into ov_applicant values g_ob_applicantinfo;

-- Insert data in g_ob_applicantinfo (Object of the OB custom type) to ov_applicant, and the applicant table contains data,

Avoid: insert into tablenames ('','', ', '') values ('','',',',', '',) This is a tedious method, especially for large table fields with many fields and hundreds

 

Change: Update ov_policy policy set policy = g_ob_policy where policy. policyid = g_ob_policy.policyid;