How do we check version of Oracle

Question

How do we check version of Oracle on which we are working?

How do we check the version of the interface on which we are working?

I have tried

select v$ from version ;

Answer 1

select banner from v$version;

should work.

you can also use.

select version from PRODUCT_COMPONENT_VERSION where rownum = 1;

Answer 2

There are multiple ways, to list a few of them :

1.

SQL> select banner from v$version where rownum=1;

BANNER
--------------------------------------------------------------------------------
Oracle Database 12c Enterprise Edition Release 12.1.0.1.0 - 64bit Production

2.

SQL> set serveroutput on;
SQL> exec dbms_output.put_line(dbms_db_version.version||'.'||dbms_db_version.release);
12.1

PL/SQL procedure successfully completed.

3.

SQL> SELECT VERSION FROM V$INSTANCE;

VERSION
-----------------
12.1.0.1.0

4.

SQL> select version from PRODUCT_COMPONENT_VERSION where rownum = 1;

VERSION
--------------------------------------------------------------------------------
12.1.0.1.0