#sql query on all pdbs

[sandeep2363]

Execute SQL script in all PDBs database Oracle

Execute SQL script in all PDBs database Oracle

Execute SQL script in all PDBs database Oracle 12c

In a CDB Environment, the catcon.pl utility is used to run SQL scripts and SQL statements in all PDBS database provide by Oracle.

catcon.pl script can run from the root container and in specified PDBs and it also have option for log files that you can view to confirm that the SQL script or SQL statement did run successfully.

Syntax for Catcon…

View On WordPress