Comments
Sort by recent activity
Thanks Richard,
Support has been very responsive and I have sent in a simpler example. I'll post it here just in case anyone is curious. drop type hr.department_t force;
drop type hr.employee_tbl_t force;
drop type hr.employee_t force;
/
create type hr.employee_t as object
(
id_num number ( 6, 0 ),
first_name varchar2 ( 20 ),
last_name varchar2 ( 25 )
);
/
create type hr.employee_tbl_t as table of hr.employee_t;
/
create type hr.department_t as object
(
id_num number ( 4, 0 ),
name varchar2 ( 30 ),
employees employee_tbl_t
);
/
create or replace view hr.departments_v of hr.department_t
with object identifier ( id_num ) as
select
d.department_id,
d.department_name,
cast ( multiset (
select
e.employee_id,
e.first_name,
e.last_name
from
hr.employees e
where
e.department_id = d.department_id
)
as hr.employee_tbl_t )
from
hr.departments d;
/
select type_text, oid_text as object_identifier_text from dba_views where owner = 'HR' and view_name = 'DEPARTMENTS_V';
Since TYPE_TEXT is not null Schema Compare should be using the OBJECT_VIEW_CLAUSE (https://docs.oracle.com/database/121/SQ ... m#i2122282)
TYPE_TEXT OBJECT_IDENTIFIER_TEXT
hr.department_t id_num / comments
Thanks Richard,
Support has been very responsive and I have sent in a simpler example. I'll post it here just in case anyone is curious.drop type hr.department_t force;
drop type hr.employee_tbl_t...