How to Find, Which product are installed or not installed in oracle database

1. Execute the query then value is true means installed and false means not installed.

SELECT parameter, VALUE
FROM v$option

2. in unix

$> opatch lsinventory -detail

Regards,

Sukhwinder singh