SQL Language (MOSC)

MOSC Banner

Select Syntax (join within containers)

edited May 5, 2018 5:03AM in SQL Language (MOSC) 2 commentsAnswered

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));

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center