Oracle DBMS_REGISTRY_EXTENDED
Version 18.1.0.0

General Information
Library Note Morgan's Library Page Header
"I spent my entire adult life looking out for the well-being, the training, the equipping of the troops for whom I was responsible. I will not be lectured about what our military needs by a five-deferment draft dodger,"
~ Sen. Tammy Duckworth
Purpose Utility supporting Preupgrade, Upgrade, and Downgrade.
AUTHID DEFINER
Dependencies Only STANDARD
Documented No
Exceptions
Error Code Reason
   
First Available 12.2.0.1
Security Model Owned by SYS with
Source {ORACLE_HOME}/rdbms/admin/dbms_registry_extended.sql
Subprograms
 
COMPARE_VERSIONS
Returns 1 if the first parameter is of a higher version than the later, zero if the same, otherwise -1

Overload 1
dbms_registry_extended.compare_versions(
version1 IN VARCHAR2,
version2 IN VARCHAR2)
RETURN NUMBER;
SQL> SELECT dbms_registry_extended.compare_versions('11.2.0.4', '12.2.0.2') AS RETVAL
  2  FROM dual;

RETVAL
------
    -1

SQL> SELECT dbms_registry_extended.compare_versions('18.1.0.0', '11.2.0.3') AS RETVAL
  2* FROM dual;

RETVAL
------
     1
Same as Overload 1 except it compares only the number of digits indicated by the "number_of_dots" parameter
Overload 2
dbms_registry_extended.compare_versions(
version1       IN VARCHAR2,
version2       IN VARCHAR2,
number_of_dots IN NUMBER)
RETURN NUMBER;
SQL> SELECT dbms_registry_extended.compare_versions('12.1.0.2', '12.1.0.1', 2) AS RETVAL
  2  FROM dual;

RETVAL
------
     0

SQL> SELECT dbms_registry_extended.compare_versions('12.1.0.2', '12.1.0.1', 2) AS RETVAL
  2  FROM dual;

RETVAL
------
     0
 
CONVERT_VERSION_TO_N_DOTS
  dbms_registry_extended.convert_version_to_n_dots(
version IN VARCHAR2,
n       IN NUMBER)
RETURN VARCHAR2;
SQL> SELECT dbms_registry_extended.convert_version_to_n_dots('18', 3)
  2  FROM dual;

DBMS_REGISTRY_EXTENDED.CONVERT_VERSION_TO_N_DOTS('18',3)
---------------------------------------------------------
18.0.0.0
 
ELEMENT
Returns the element between the specified delimiters in the element_number position dbms_registry_extended.element(
src            IN VARCHAR2,
delimiter      IN CHAR,
element_number IN NUMBER)
RETURN VARCHAR2;
SQL> SELECT dbms_registry_extended.element('12.2.0.1', '.', 3)
  2  FROM dual;

DBMS_REGISTRY_EXTENDED.ELEMENT('12.2.0.1','.',3)
-------------------------------------------------
0

SQL> SELECT dbms_registry_extended.element('12.2.0.1', '.', 1)
  2  FROM dual

DBMS_REGISTRY_EXTENDED.ELEMENT('12.2.0.1','.',1)
------------------------------------------------
12
 
OCCURS
Returns the number of occurrences of the search string in the source dbms_registry_extended.occurs(
src           IN VARCHAR2,
search_string IN VARCHAR2)
RETURN NUMBER;
SQL> SELECT dbms_registry_extended.occurs('Dan Morgan', 'an')
  2  FROM dual;

DBMS_REGISTRY_EXTENDED.OCCURS('DANMORGAN','AN')
-----------------------------------------------
                                              2

Related Topics
Built-in Functions
Built-in Packages
DBMS_REGISTRY
DBMS_REGISTRY_SERVER
DBMS_REGISTRY_SIMPLE
DBMS_REGISTRY_SYS
What's New In 12cR1
What's New In 12cR2

Morgan's Library Page Footer
This site is maintained by Dan Morgan. Last Updated: This site is protected by copyright and trademark laws under U.S. and International law. © 1998-2017 Daniel A. Morgan All Rights Reserved