My Oracle Support Banner

Oracle Database 12.1 : FAQ on Queryable Patch Inventory (Doc ID 1530108.1)

Last updated on SEPTEMBER 01, 2023

Applies to:

Oracle Database - Enterprise Edition - Version and later
Oracle Database - Standard Edition - Version and later
Oracle Database Cloud Schema Service - Version N/A and later
Gen 1 Exadata Cloud at Customer (Oracle Exadata Database Cloud Machine) - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Information in this document applies to any platform.


 To expain the new feature Queryable Patch Inventory introduced in 12c

Questions and Answers

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document
Questions and Answers
 What is Queryable Patch Inventory  ?
 What package(s) are provided for Queryable Patch Inventory ?
 What objects are related to Queryable Patch Inventory ?
 What are the APIs/functions/procedures provided by DBMS_QOPATCH PACKAGE ?
 How to execute these Functions/Procedure ?
 Error which might be encountered during execution of Queryable Patch Inventory
 Can we have define our own style sheet instead of using the default one ?
 Queryable Patch Inventory Examples
 Known Issues/Limitations
 <Internal_Only>Key words added as per the comment " 12cR1 12cR1 12cR1 12CR1 12CR1 12CR1 12c 12c</Internal_Only>

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.