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:
 
Home      :      Code Library      :      Sponsors      :      Privacy      :      Terms of Use      :      Contact Us 190 users online    © 2009 psoug.org
PSOUG LOGIN
Username: 
Password: 
Forgot your password?