oracle question

[miteycasey]

Is there a command I can run to find out what version of Oracle is installed?

<rant>I love getting DBA questions as a sysadmin especially since this isn't a box I support.</rant>

[bradfordgd]

connecting to oracle with sqlplus will tell you what verison is running;

oracle % sqlplus version

SQL*Plus: Release 9.0.1.0.0 - Production on Tue Aug 31 15:33:17 2004

(c) Copyright 2001 Oracle Corporation. All rights reserved.

Enter password: