Queries below return server version, edition and system information.

Using V$VERSION

Query

select * from V$VERSION

Columns

• banner - string containing server information

Rows

Query returns many rows, each containing information about core Oracle component.

Sample results

Oracle 11g XE on Linux server:

Oracle 9i on AIX server:

Using V$INSTANCE

If you have dba privilege you can access database version information in V$INSTANCE view

Query

select version from V$INSTANCE

Columns

• version - database version information

Rows

Query returns just one row

Sample results

Oracle 11g XE:

Oracle 9i:

Releases

Oracle is using release naming convention. You can translate version number to release name for contemporary releases with this table: