I was just asked to see what version/type of Oracle was installed on an Win NT 4.0 box. I know I can connect to the database and type Select * from v$version. But this only gives me the version number(Oracle 8i Release 8.1.6.0.0). What I would like to know is if the machine was installed with Oracle Workgroup, Oracle Personal Edition, Enterprise Edition, Oracle Client, etc. in addition to just the version number.

Thanks.