Have Geek Brain

Database version of the program?

Can I get more information about a program using an Oracle database other than as an exe? I would like to have an exes version number and / or a hashcode or something else that allows me to uniquely distinguish one exe version from another.

I do not need to search for this information in the program code, since an administrator like Toad och Sql Developer will do everything.

0


a source to share


2 answers


Can you change the exe-s in the question (i.e. in the internal application)?

If so, you can set the version number using the DBMS_APPLICATION_INFO ...



http://www.orafaq.com/wiki/DBMS_APPLICATION_INFO

+1


a source


The only way I can reliably get the information I want is to find the OS process id (v $ session) and then use ps or something like taskmanager.exe to get the details from the OS of the client systems.



This sounds cumbersome, but scripting is possible if you have sufficient rights on the client application hosts.

0


a source






More articles:


All Articles