Oracle / PLSQL - Retrieve the Oracle version information

I involve myself with Oracle database. It quite different from MySQL and MsSQL. Somehow each Oracle database has different queries statement to retrieve and manipulate the data.

I not going details in this post, I will show how to get Oracle information :

SELECT * FROM v$version;

BANNER
--------------------------------------------------------------------------------
Oracle Database 11g Release 11.2.0.4.0 - 64bit Production
PL/SQL Release 11.2.0.4.0 - Production
CORE    11.2.0.4.0      Production
TNS for Linux: Version 11.2.0.4.0 - Production
NLSRTL Version 11.2.0.4.0 - Production

5 rows selected.

Wassalam ~

Related Posts

• 02 Nov 2018 » IBMs acquisition of Red Hat
• 27 Sep 2018 » Generate XML using SQL query with Oracle database

Discussion and feedback