how to get all oracle components version ?
You can use 2 queries to get oracle components version:
1. select * from product_component_versionin 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$versionthat 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: oracle
