Quick Search:


	CODE Oracle PL/SQL Code Library


	JOBS Find Or Post Oracle Jobs


	FORUM Oracle Discussion & Chat

The Oracle PL/SQL RELEASE Keyword [Return To Index]

Jump to:

Looking for the original pages? (formerly called "Morgan's Library") You can find them here.

Term: RELEASE

Definition:
In Oracle PL/SQL, the RELEASE keyword is used to specify the version of the Oracle product. For example, Oracle 11g release means the "11g version of the Oracle Database".

The release version can be identified in SQL by querying V$VERSION in the data dictionary.

Example Usage:

The SQL query below lists the properties of currently installed database version.

SQL> SELECT * FROM V$VERSION;

Related Code Snippets:

Display and release DBMS_LOCK locks - Release DBMS_LOCK locks on database.

Home : Code Library : Sponsors : Privacy : Terms of Use : Contact Us

PSOUG LOGIN
Username:
Password: