Tag Archives: Materialized View

Materialized View with OID users data

Sometimes you need access users data of OID to integrate with other systems, follow bellow how to do:   1. Create Types : CREATE OR REPLACE TYPE LDAP_USU_TABLE is table of LDAP_USU_ROW; / CREATE OR REPLACE TYPE LDAP_USU_ROW as object (login       varchar2(200),            name        varchar2(200),            mail        varchar2(200),            phone      varchar2(200)); /   […]