Как узнать версию оракла запросом
Перейти к содержимому

Как узнать версию оракла запросом

  • автор:

Oracle / PLSQL: Retrieve Oracle version information

This Oracle tutorial explains how to find the Oracle version information with syntax and examples.


You can check the Oracle version by running a query from the command prompt. The version information is stored in a table called v$version. In this table you can find the version information for Oracle, PL/SQL, etc.


The syntax to retrieve the Oracle version information is:

Parameters or Arguments

There are no parameters or arguments.


Let’s look at some of examples of how to retrieve version information from Oracle.

All Version Information

To retrieve all version information from Oracle, you could execute the following SQL statement:

This query would output something like this:

Oracle Version Only

If you only wanted the Oracle version information, you execute the following SQL statement:

how to find the Oracle database version

Many times question is being asked about how to find the Oracle database version and version of various Oracle utilities in Linux, Solaris, AIX, and windows. Let’s check out how is the oracle database version defined and How to find the Oracle database version

Table of Contents

Oracle Database Versions

  • Oracle has released various versions of the Oracle database starting in 1979. They release Oracle 8i in 1998 where “i” stand for the internet.
  • They release Oracle 10g in 2003 where “g” stands for grid.
  • Then they release Oracle 12c in 2013 where “c” stands for the cloud.
  • After that, they continued year-wise starting in 2018. So 2018 was 18c Release, 2019 was 19c Release, and so on.
  • The latest version right now is 21c released in 2021. They are terming some versions as innovation releases and some as Long term releases.
  • Innovation releases have shorter support periods ie. 2 years and long-term releases have 7-8 year support periods. So businesses can choose the release accordingly.
  • Right Now, 19c is the long-term release, and 18c,20c, and 21c are innovation releases. The next long-term release will 23c

how to check oracle database version in Linux or any OS/how to check oracle version in linux

We can easily check the version using any of these three methods. You need to source the environment and then they can use any of these methods

you could use opatch also

How to find client sqlplus version in use

How to find the version of expdp

How to find the version of the nid utility

How to find the version of exp

How to find the version of rman

how to check oracle version in sql developer

  • In SQL Developer, click the Reports tab on the left, near the Connections navigator. (If this tab is not visible, click View, then Reports.)
  • In the Reports navigator, expand Data Dictionary Reports.
  • Under Data Dictionary Reports, expand About Your Database.
  • Under About Your Database, click Version Banner.

how to check oracle client version in linux

We can simply do these to find it

Some Explanation about Version

Major Database Release Number The first digit is the most general identifier. It represents a major new version of the software that contains significant new functionality.
Database Maintenance Release Number The second digit represents a maintenance release level. Some new features may also be included.
Application Server Release Number The third digit reflects the release level of the Oracle Application Server (OracleAS).
Component-Specific Release Number The fourth digit identifies a release level specific to a component. Different components can have different numbers in this position depending upon, for example, component patch sets or interim releases.
Platform-Specific Release Number The fifth digit identifies a platform-specific release. Usually, this is a patch set. When different platforms require the equivalent patch set, this digit will be the same across the affected platforms.

Also reads
Oracle database cloning: Check this page for Oracle database cloning which is an important role of an Oracle DBA. See steps by steps instructions with an explanation
DBMS_REDEFINITION : Online table redefinition allows for modification of the table structure definition without significantly affecting the availability of the table.
CPU vs Core Vs Socket: Find out what is CPU vs Core Vs Socket, difference and how to find them in windows using the different commands in an easy manner,
clone database from cold backup: This post consists of step by step detailed instructions to clone the oracle database using the cold backup database cloning method
dbms_metadata.get_ddl materialized view: Check out how to get table definition in oracle, oracle show index definition, get ddl of a materialized view in oracle, get the query of a view in oracle

Recommended Courses

The following are some of the recommended courses you can buy if you want to get a step further

Given below are the links to some of the courses

Oracle DBA 11g/12c – Database Administration for Junior DBA : This course is good for the people who are starting as Junior DBA or aspire to be Oracle DBA. This will provide a good understanding of backup & recovery and General administration tasks
Oracle Database: Oracle 12C R2 RAC Administration : This course covers the installation, administration of Oracle RAC. A good course for Oracle DBA who want to upgrade his skills for Oracle RAC
Oracle Data Guard: Database Administration for Oracle 12C R2 : This course covers the installation, administration of Oracle Dataguard. A good course for Oracle DBA who want to upgrade his skills for Oracle Dataguard

Oracle / PLSQL: Checking Oracle Version Information

This post explains how to check Oracle version information running on Linux and windows.


You can check Oracle version using SQL plus query. Oracle database could be running on Linux and windows and we can simply find out version information from v$version view from SQL Developer or SQL Plus command prompt.

Retrieve Oracle Version information

Conclusion: If you are checking what Oracle Version you are running then you can use above query which will show you the correct database version running on Linux or windows.


Как узнать нужную версию JDeveloper для OA Framework

Нота на металинке:
Как определить версию OAF

Заходим на любую HTML страницу OEBS и кликаем по ссылке О данной странице .
Переходим на вкладку Компоненты технологии

Похожие записи:

Подскажите, пожалуйста, у меня текущая локальная версия
Oracle IDE
OA Framework 11.5.10RUP6 (903813_1566_4)
На сервере
Структура OA
Oracle Applications Extension — build 1570
Какую версию JDeveloper мне нужна что бы все корректно отрабатывало?

Если смотреть по ноте (ссылка в начале статьи)

11i.ATG_PF.H.RUP6 — 9IJDeveloper With OA Extension ARU FOR 11i10 RUP6 (Patch 6739235)

11i.ATG_PF.H.delta.7 — 9I JDEVELOPER WITH OA EXTENSION ARU FOR 11I RUP7 (Patch 8751878)

Раз на сервере стоит RUP7, то и разрабатывать надо под него.

rudev, здравствуйте!
Стоит патч RUP7, по ноте следует, что нужен указанный патч под JDeveloper 9i. На сайте oracle минимально возможный для скачивания JDev — 10g. 9й больше не поддерживается Ораклом? 9i еще и проблема скачать в инете

Добавить комментарий

Ваш адрес email не будет опубликован. Обязательные поля помечены *