clear markdown compare help best fiddles feedback dbanow.uk 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;
BANNER
Oracle Database 11g Express Edition Release 11.2.0.2.0 - 64bit Production
PL/SQL Release 11.2.0.2.0 - Production
CORE 11.2.0.2.0 Production
TNS for Linux: Version 11.2.0.2.0 - Production
NLSRTL Version 11.2.0.2.0 - 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 p.id = 1 and a.id = 99
1 rows affected
 hidden batch(es)


select r.pers.id, r.pers.name, r.addr.id, r.addr.address from address_person r
PERS.ID PERS.NAME ADDR.ID ADDR.ADDRESS
1 name1 99 address99
 hidden batch(es)