DBMS_QOPATCH Package

Up to 12c version for patches / ONEOFF we had installed in a database, we need to use the command line opatch previously setting it to point to the appropriate database. Since version 12c Oracle package includes DBMS_QOPATCH, which gives us the same information, but can run as pl / sql. The following query returns us list of installed patches,.

 

 SELECT 
  XMLTRANSFORM(DBMS_QOPATCH.GET_OPATCH_LIST, DBMS_QOPATCH.GET_OPATCH_XSLT) 
FROM DUAL;

 

Please for more information refer to Oracle Doc. since this package has many more options;

http://docs.oracle.com/database/121/ARPLS/d_qopatch.htm#ARPLS74834

 

HTH – Antonio NAVARRO

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s