Search notes:

Columns in V$CONTAINERS and V$PDBS

v$containers and v$pdbs have most columns in common:
con_id ✓ ✓ Also present in v$database
dbid ✓ ✓ Also present in v$database
con_uid ✓ ✓
guid ✓ ✓
name ✓ ✓ Also present in v$database
open_mode ✓ ✓ Also present in v$database
restricted ✓ ✓
open_time ✓ ✓
create_scn ✓ ✓
total_size ✓ ✓
block_size ✓ ✓
recovery_status ✓ ✓
snapshot_parent_con_id ✓ ✓
application_root ✓ ✓
application_pdb ✓ ✓
application_seed ✓ ✓
application_root_con_id ✓ ✓
application_root_clone ✓ ✓
proxy_pdb ✓ ✓
local_undo ✓ ✓
undo_scn ✓ ✓
undo_timestamp ✓ ✓
creation_time ✓ ✓
diagnostics_size ✓
pdb_count ✓ ✓
audit_files_size ✓ ✓
max_size ✓ ✓
max_diagnostics_size ✓ ✓
max_audit_size ✓ ✓
last_changed_by ✓ ✓
member_cdb ✓
tenant_id ✓ ✓
template ✓
upgrade_level ✓ ✓
guid_base64 ✓ ✓
recovery_target_pdb_incarnation# ✓ Added in 21c.
cloud_identity ✓ ✓ A varchar2(4000) column whose content is a JSON object. Added in 21c.
close_time ✓ ✓ Added in 21c.
union all … 
select 'gv$pdbs'       src,name,dbid,con_id,con_uid,null member_cdb,     template,application_root, undo_scn,open_mode,block_size,max_size,local_undo,creation_time,open_time,application_root_con_id,total_size,proxy_pdb,pdb_count,close_time,upgrade_level,cloud_identity,max_audit_size,create_scn,application_root_clone,restricted,application_seed,     recovery_target_pdb_incarnation#,snapshot_parent_con_id,last_changed_by,recovery_status,application_pdb,undo_timestamp,max_diagnostics_size,audit_files_size,     diagnostics_size,inst_id,tenant_id,guid,guid_base64 from gv$pdbs union all
select 'gv$containers' src,name,dbid,con_id,con_uid,     member_cdb,null template,application_root, undo_scn,open_mode,block_size,max_size,local_undo,creation_time,open_time,application_root_con_id,total_size,proxy_pdb,pdb_count,close_time,upgrade_level,cloud_identity,max_audit_size,create_scn,application_root_clone,restricted,application_seed,null recovery_target_pdb_incarnation#,snapshot_parent_con_id,last_changed_by,recovery_status,application_pdb,undo_timestamp,max_diagnostics_size,audit_files_size,null diagnostics_size,inst_id,tenant_id,guid,guid_base64 from gv$containers;
Query the attributes that gv$database has in common with gv$pdbs and gv$containers: 
select name, con_id, dbid, open_mode from gv$database;
Some of the data in the table above was queried with 
with a as (select * from dba_tab_columns where owner = 'SYS' and table_name = 'V_$PDBS'      ),
     b as (select * from dba_tab_columns where owner = 'SYS' and table_name = 'V_$CONTAINERS'),
     c as (select * from dba_tab_columns where owner = 'SYS' and table_name = 'V_$DATABASE'  )
select
     lower(coalesce(a.column_name, b.column_name, c.column_name))  col_name,
     case when a.column_name is not null then 'X' end              pdbs,
     case when b.column_name is not null then 'X' end              containers,
     case when c.column_name is not null then 'X' end              database
from
     a                                                             full outer join
     b on          a.column_name = b.column_name                   full outer join
     c on coalesce(a.column_name , b.column_name) = c.column_name
order by
     coalesce (a.column_name, b.column_name, c.column_name);

Index