Query to Check the PL/SQL and Oracle Database Version

It becomes a necessity to sometimes check the version of Oracle database being used or to check the version of PL/SQL being used.To check which Oracle database you are working on and also to check which PL/SQL release , the query used :

          

select  *  from  v$version ;

This query can be tested on sql*Plus , SqlDeveloper or any other query executable tools.Along the above version details you could see the CORE version , TNS version and NLSRTL version

The Complete query result would look like this :

                                                     ( click on the image to expand )