12c database syntaxes

• Create a pluggable database.

SQL> create pluggable database pdb12c admin user john identified by doe;
SQL> alter pluggable database pdb12c open;

• Show con_name and con_id.

SQL> show con_name

CON_NAME
------------------------------
CDB$ROOT

SQL> show con_id

CON_ID
------------------------------
1

• Display all services

SQL> select name, con_id from v$active_services order by 1;

NAME								     CON_ID
---------------------------------------------------------------- ----------
SYS$BACKGROUND								  1
SYS$USERS								  1
cdb12c.localdomain							  1
cdb12cXDB								  1
pdb12c.localdomain							  3

• Create a user in the pluggable database.

-- Cannot create a user in the container database.
SQL> create user test identified by test;
create user test identified by test
            *
ERROR at line 1:
ORA-65096: invalid common user or role name

-- Switch to the pluggable database first.
SQL> alter session set container=pdb12c;
Session altered.

-- Verify
SQL> show con_name
CON_NAME
------------------------------
PDB12C

SQL> show con_id
CON_ID
------------------------------
3

SQL> create user test identified by test;
User created.