SQL QUERY TO FIND OUT THE STATUS OF GENISYS PATCH LOADING IN THE DATABASE

We can find out what are the Genisys Patches / Versions loaded in the Genisys Database by executing below mentioned SQL query.   START ---> RUN ---> CMD   C:\>SET ORACLE_SID = INS   C:\>sqlplus "/as sysdba"   This command will successful, if the entry   "SQLNET.AUTHENTICATION_SERVICES=NTS"  in   E:\Oracle\Ora92\Network\Admin\sqlnet.ora"   SQL>   SQL>SELECT * FROM GEN_PARAM_TABLE WHERE LOWER(TXT_PARAM_CODE) LIKE '%GLOBAL%';   ***THIS SQL QUERY WILL HELP THE ADMINISTRATOR TO KNOW THE STATUS OF PATCHES LOADED TILL DATE***     Nageswaran AG