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;

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

5 rows selected.

Wassalam ~

Actions Speak Louder Than Words!

Powered by Jekyll and Hydejack v7.3.0