Wednesday, April 27, 2011

Oracle Product information by single query? Easy.

Easy to do:
select * from product_component_version
Results:
PRODUCT
VERSION
STATUS
NLSRTL
11.2.0.1.0
Production
Oracle Database 11g Enterprise Edition
11.2.0.1.0
64bit Production
PL/SQL
11.2.0.1.0
Production
TNS for 64-bit Windows:
11.2.0.1.0
Production

No comments:

Post a Comment