Queryable Patch Inventory or DBMS_QOPATCH
New in Oracle 12c is queryable Opatch. Oracle offers a set of tables and a PL/SQL packages to query the Oracle Inventory.Prior to Oracle 12c, it was not easy to List Oracle patches. Now from Oracle 12c and beyond, you can use the DBMS_QOPATCH package to list all patches. Using DBMS_QOPATCH ; Oracle Database 12c has a PL/SQL - SQL interface for viewing patch information using a select statement instead a OS ORACLE opach command. This new interface view all the patch information available as part of the , OPatch lsinventory -xml command conform the the OS Oracle opatch command. The package DBMS_QOPATCH accesses the Oracle Universal Installer (OUI) patch inventory in real time to provide patch and patch meta information.