Search notes:

Oracle: CONTAINERS clause in SELECT statements

select statements using the containers() clause are executed in each queried PDB
If the queried table does not have a CON_ID column, such a column is added.
The following select statement is a simple demonstration that containers adds the column con_id and returns a resultset for every PDB: 
select
   dual.dummy,
   con_id,
   con_id_to_con_name(con_id)  con_name
from
   containers(dual);

See also

The containers hint.

Index

Fatal error: Uncaught PDOException: SQLSTATE[HY000]: General error: 8 attempt to write a readonly database in /home/httpd/vhosts/renenyffenegger.ch/php/web-request-database.php:78 Stack trace: #0 /home/httpd/vhosts/renenyffenegger.ch/php/web-request-database.php(78): PDOStatement->execute(Array) #1 /home/httpd/vhosts/renenyffenegger.ch/php/web-request-database.php(30): insert_webrequest_('/notes/developm...', 1759974007, '216.73.216.133', 'Mozilla/5.0 App...', NULL) #2 /home/httpd/vhosts/renenyffenegger.ch/httpsdocs/notes/development/databases/Oracle/SQL/select/containers(48): insert_webrequest() #3 {main} thrown in /home/httpd/vhosts/renenyffenegger.ch/php/web-request-database.php on line 78