Execute SQL in multiple containers
- Written by: ilmarkerm
- Category: Blog entry
- Published: March 6, 2023
It is possible to use DBMS_SQL to execute dynamic SQL in multiple pluggable databases, from CDB. Oracle does provide CONTAINERS clause, but the use of it is quite limited.
In this example I execute from CDB and I’m stopping all services in all PDB-s, transactionally.