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 ~


Actions Speak Louder Than Words!

Powered by Jekyll and Hydejack v7.3.0