Search notes:

SQL*PLUS: SHOW PDBS

show pdbs display the names, ids, mode and restriction status of the Pluggable Databases in the consolidated database to which the user is connected.
$ sqlplus / as sysdba
   …
SQL> show pdbs

    CON_ID CON_NAME                       OPEN MODE  RESTRICTED
---------- ------------------------------ ---------- ----------
         2 PDB$SEED                       READ ONLY  NO
         3 PDBTQ84                        READ WRITE NO

See also

SQL*Plus, the show command.
show con_id and show con_name (Only available with SYSDBA privileges, otherwise SP2-0382: The SHOW PDBS command is not available is thrown).

Index