{"id":599,"date":"2023-03-06T09:11:30","date_gmt":"2023-03-06T08:11:30","guid":{"rendered":"https:\/\/ilmarkerm.eu\/blog\/?p=599"},"modified":"2023-03-06T09:11:30","modified_gmt":"2023-03-06T08:11:30","slug":"execute-sql-in-multiple-containers","status":"publish","type":"post","link":"https:\/\/ilmarkerm.eu\/blog\/2023\/03\/execute-sql-in-multiple-containers\/","title":{"rendered":"Execute SQL in multiple containers"},"content":{"rendered":"\n<p>It is possible to use DBMS_SQL to execute dynamic SQL in multiple pluggable databases, from CDB. <a href=\"https:\/\/oracle-base.com\/articles\/12c\/multitenant-pdb-containers-clause-12c\" data-type=\"URL\" data-id=\"https:\/\/oracle-base.com\/articles\/12c\/multitenant-pdb-containers-clause-12c\" target=\"_blank\" rel=\"noreferrer noopener\">Oracle does provide CONTAINERS clause, but the use of it is quite limited.<\/a><\/p>\n\n\n\n<p>In this example I execute from CDB and I&#8217;m stopping all services in all PDB-s, transactionally.<\/p>\n\n\n\n<script src=\"https:\/\/gist.github.com\/ilmarkerm\/3a0f36a3092cbaf35f60cc7bedce5f7d.js\"><\/script>\n","protected":false},"excerpt":{"rendered":"<p>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&#8217;m stopping all services in all PDB-s, transactionally.<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[4],"class_list":["post-599","post","type-post","status-publish","format-standard","hentry","category-blog-entry","tag-oracle"],"_links":{"self":[{"href":"https:\/\/ilmarkerm.eu\/blog\/wp-json\/wp\/v2\/posts\/599","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/ilmarkerm.eu\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/ilmarkerm.eu\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/ilmarkerm.eu\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/ilmarkerm.eu\/blog\/wp-json\/wp\/v2\/comments?post=599"}],"version-history":[{"count":1,"href":"https:\/\/ilmarkerm.eu\/blog\/wp-json\/wp\/v2\/posts\/599\/revisions"}],"predecessor-version":[{"id":600,"href":"https:\/\/ilmarkerm.eu\/blog\/wp-json\/wp\/v2\/posts\/599\/revisions\/600"}],"wp:attachment":[{"href":"https:\/\/ilmarkerm.eu\/blog\/wp-json\/wp\/v2\/media?parent=599"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/ilmarkerm.eu\/blog\/wp-json\/wp\/v2\/categories?post=599"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/ilmarkerm.eu\/blog\/wp-json\/wp\/v2\/tags?post=599"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}