Oracle: DBA_PDBS

dba_pdbs lists all PDBs that belong to a given CDB:

• In a CDB root: all PDBs of this root
• An an application root: the PDBs of the application container
• In a regular PDB or in an application PDB: itself