archive “2008/03”

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          Production
Oracle9i Enterprise E... Production
PL/SQL          Production
TNS for Solaris: Production

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


2. select * from v$version

that returns same result as above but all fields is concated

Oracle9i Enterprise Edition Release 9.2...
PL/SQL Release - Production
CORE Production
TNS for Solaris: Version - Produ...
NLSRTL Version - Production
oracle comments no comment

last tweet