clear markdown compare help best fiddles feedback a leap of faith?
clear markdown donate comments/suggestions/bugs a leap of faith? bible365 diddy dollings
By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0. 2335598 fiddles created (27425 in the last week).

select * from V$VERSION;
Oracle Database 11g Express Edition Release - 64bit Production
PL/SQL Release - Production
CORE Production
TNS for Linux: Version - Production
NLSRTL Version - Production
 hidden batch(es)

create or replace type person force as object (id int, name varchar2 (8)) /
 hidden batch(es)

create or replace type address as object (id int, address varchar2 (16)) /
 hidden batch(es)

create table persons of person (id primary key)
 hidden batch(es)

create table addresses of address (id primary key)
 hidden batch(es)

create table address_person ( pers ref person scope is persons, addr ref address scope is addresses)
 hidden batch(es)

insert all into persons values (person ( 1, 'name1')) into addresses values (address (99, 'address99')) select null from dual
2 rows affected
 hidden batch(es)

insert into address_person select ref (p), ref (a) from persons p, addresses a where = 1 and = 99
1 rows affected
 hidden batch(es)

select,,, r.addr.address from address_person r
1 name1 99 address99
 hidden batch(es)