SyntaxFix

[oracle] How to check Oracle patches are installed?

I understand the original post is for Oracle 10 but this is for reference by anyone else who finds it via Google.

Under Oracle 12c, I found that that my registry$history is empty. This works instead:

select * from registry$sqlpatch;

Examples related to oracle

• concat yesterdays date with a specific time • ORA-28001: The password has expired • how to modify the size of a column • How to create a blank/empty column with SELECT query in oracle? • Find the number of employees in each department - SQL Oracle • Query to display all tablespaces in a database and datafiles • When or Why to use a "SET DEFINE OFF" in Oracle Database • How to insert date values into table • error: ORA-65096: invalid common user or role name in oracle • In Oracle SQL: How do you insert the current date + time into a table?

Examples related to patch

• Create patch or diff file from git repository and apply it to another different git repository • How to check Oracle patches are installed? • What is the main difference between PATCH and PUT request? • Using python's mock patch.object to change the return value of a method called within another method • How do I simply create a patch from my latest git commit? • How to generate a git patch for a specific commit? • How to apply `git diff` patch without Git installed? • How to move certain commits to be based on another branch in git? • How to apply a patch generated with git format-patch? • How do I apply a diff patch on Windows?