Oracle: SQL functions that are useful in a CDB

SQL functions that are useful in a container database (CDB) include:

• con_dbid_to_id
• con_guid_to_id
• con_id_to_con_name
• con_id_to_dbid
• con_name_to_id
• con_uid_to_id

These functions return 0 if executed in a non-CDB.

select
   con.name,
   con_name_to_id(con.name),
   con.con_id
from
   v$containers con;

select
   dual.dummy,
   con_id,
   con_id_to_con_name(con_id)  con_name
from
   containers(dual);