Select Syntax (join within containers)
I am looking for the correct syntax to perform joins with the container.
Test Script:
create user c##pojen identified by oracle_4U;
grant dba,set container to c##pojen container=ALL;
create pluggable database PLAY1 admin user admin identified by oracle_4U;
create pluggable database WORK1 admin user admin identified by oracle_4U;
alter pluggable database all open;
connect c##pojen/oracle_4U
create table c##pojen.po (eid number, ename varchar2(255));
create table c##pojen.jen(eid number, ename varchar2(255));
alter session set container=PLAY1;
create table c##pojen.po (eid number, ename varchar2(255));
create table c##pojen.jen(eid number, ename varchar2(255));