How to know the version of Oracle?
How do I get the version number from an Oracle Server?
Ans1:
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"
Ans2:
Starting SQL*Plus under NT will give you the result.
Ans3:
Select * from v$version;