Chapter 8. DBMS_DB_VERSION
Prev   Next

Chapter 8. DBMS_DB_VERSION

Table of Contents

8.1. Overview
8.2. Constants
8.2.1. MAJOR
8.2.2. MINOR

This chapter describes the basic concepts of DBMS_DB_VERSION package and how to use it.

8.1. Overview

DBMS_DB_VERSION package provides the product version information.

8.2. Constants

This section describes the constants provided by DBMS_DB_VERSION package in alphabetical order.

8.2.1. MAJOR

Represents the major version number as an INTEGER.

Details are as follows:

  • Prototype

    DBMS_DB_VERSION.MAJOR

  • Example

    BEGIN
   if DBMS_DB_VERSION.MAJOR = 6 then
      DBMS_OUTPUT.PUT_LINE(DBMS_DB_VERSION.MAJOR);
   end if;
END;
/

8.2.2. MINOR

Represents the minor version number as an INTEGER.

Details are as follows:

  • Prototype

    DBMS_DB_VERSION.MINOR

  • Example

    BEGIN
   if DBMS_DB_VERSION.MINOR < 1 then
      DBMS_OUTPUT.PUT_LINE(DBMS_DB_VERSION.MINOR);
   end if;
END;
/
Prev   Next
Chapter 7. DBMS_CRYPTO Home Chapter 9. DBMS_DDL