Get Information about Current Database Version.

Get Information about Current Database Version.

If you need to open Service request , you have to know what is your database version .

Open SQLPLUS 

Write this simple code (User should be with DBA privileges)

/> select * from v$version;

Oracle Database 11g Enterprise Edition Release 11.1.0.7.0 - 64bit Production

PL/SQL Release 11.1.0.7.0 - Production

CORE       11.1.0.7.0                Production

TNS for Linux: Version 11.1.0.7.0 - Production

NLSRTL Version 11.1.0.7.0 - Production

IF you need to know your current privileges

/> SELECT GRANTED_ROLE FROM DBA_ROLE_PRIVS WHERE

GRANTEE = 'HR'

RESOURCE

CONNECT