Oracle DB : Finding the DB version and Other important details

Its pretty common for us to check the DB version and sometimes the parameters that help in most of the activities that we do on a daily basis below are some that might help.


Database Version:


for just the version number 

        SELECT version FROM V$INSTANCE;

For version details of other tools of Database 

        SELECT * FROM V$VERSION;

NLS Parameters

For all the NLS parameters of database 

        SELECT * FROM V$NLS_PARAMETERS;

For Just Language , Region and Character Set

        SELECT DECODE(PARAMETER, 

        'NLS_CHARACTERSET',  'CHARACTER SET',

        'NLS_LANGUAGE', 'LANGUAGE',

        'NLS_TERRITORY', 'TERRITORY') NAME,

        VALUE FROM V$NLS_PARAMETERS

        WHERE PARAMETER IN ( 'NLS_CHARACTERSET', 'NLS_LANGUAGE', 'NLS_TERRITORY');