Which two options can you use to list Oracle Database 12c patches by using Queryable Patch Inventory?

Which two options can you use to list Oracle Database 12c patches by using Queryable Patch
Inventory?

Which two options can you use to list Oracle Database 12c patches by using Queryable Patch
Inventory?

A.
select patch from vSoption where opatch_data=’ 333333′ ;

B.
select xmltransform(dbms_qopatch.get_opatch_data(3333333),
dbms_qopatch.GET_OPATCH_XSLT()) from dual

C.
select opatch from vSpatchsets where opatch_number = ‘333333’;

D.
opatchlsinventory -xml

Explanation:
Reference:http://www.oracle.com/technetwork/pt/articles/sql/queryable-patch-inventory-12c-2098576-ptb.html

Show Hint

Leave a Reply 2

Your email address will not be published. Required fields are marked *

Prateek

Prateek

Answer : BD

Explanation :
https://www.oracle.com/technetwork/pt/articles/sql/queryable-patch-inventory-12c-2098576-ptb.html

$ORACLE_HOME/OPatch/opatch lsinventory -xml

SQL> select xmltransform(DBMS_QOPATCH.GET_OPATCH_LSINVENTORY,
DBMS_QOPATCH.GET_OPATCH_XSLT) from dual;

SQL> select xmltransform(DBMS_QOPATCH.GET_OPATCH_BUGS,
DBMS_QOPATCH.GET_OPATCH_XSLT) from dual;

DBMS_QOPATCH.GET_OPATCH_DATA (patchnum IN VARCHAR2); RETURN XMLTYPE;
This function provides top level patch information for the patch (such as Patch ID, patch creation time) in the XML element.

Reply