Search notes:

Oracle: V$CONTAINERS

Select a PDB's containers

The following query lists all containers in a CDB, including the seed and the CDB root:

select
   name,
   con_id,
   dbid,
   con_uid,
   guid
from
   v$containers
order by
   con_id;