SELECT 'Version' Module,
"V$VERSION"."BANNER",
null
FROM "V$VERSION"
UNION ALL
SELECT 'Options' Module,
"V_$OPTION"."PARAMETER",
"V_$OPTION"."VALUE"
FROM "SYS"."V_$OPTION"
--
Terry Dykstra (TeamPS)
Canadian Forest Oil Ltd.
andrewf_at_jaredgroup.com wrote in message <7b1pj8$9ro$1_at_nnrp1.dejanews.com>...
>How do I get the version number from an Oracle Server?
>
>-----------== Posted via Deja News, The Discussion Network ==----------
>http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own
Received on Wed Feb 24 1999 - 17:52:23 CST
