tag ‍“oracle”

how to get all oracle components version ?

by Hamid Reza Fahimi Madjd @ Mar 3, 2008

You can use 2 queries to get oracle components version:

1. select * from product_component_version

in this case you get result like below

PRODUCT                  VERSION   STATUS
---------------------------------------------
NLSRTL                   9.2.0.1.0 Production
Oracle9i Enterprise E... 9.2.0.1.0 Production
PL/SQL                   9.2.0.1.0 Production
TNS for Solaris:         9.2.0.1.0 Production

all fields have crystal clear contents, so i won't describe them

or

2. select * from v$version

that returns same result as above but all fields is concated

BANNER
---------------------------------------------
Oracle9i Enterprise Edition Release 9.2...
PL/SQL Release 9.2.0.1.0 - Production
CORE 9.2.0.1.0 Production
TNS for Solaris: Version 9.2.0.1.0 - Produ...
NLSRTL Version 9.2.0.1.0 - Production

oracle no comment