Re: What Versions are Installed

spelegan_at_csc.com wrote:

>
> Is there some SQL script or some app. I can run that will tell me what
> Oracle components I have installed and which version of these components
> are installed. I'd also like to do this from the command line. Thanks.

select banner from v$version;

and/or

select * from v$option;

and/or

SELECT comp_name, status, substr(version,1,10) as version FROM dba_registry;

Perhaps.

-- 
Daniel Morgan
http://www.outreach.washington.edu/ext/certificates/oad/oad_crs.asp
http://www.outreach.washington.edu/ext/certificates/aoa/aoa_crs.asp
damorgan_at_x.washington.edu
(replace 'x' with a 'u' to reply)