Sunday, July 5, 2015

How to find version of Oracle?


SELECT version FROM V$INSTANCE; -- we can get exact version of database
/
SELECT * FROM V$VERSION; -- we can get detail information along with version (like bit - windows 32bit or 64 bit ....)

No comments:

Post a Comment