Monday, March 3, 2008

how to get all oracle components version ?

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

Labels: