Main Tables Views Indexes Constraints Triggers Procedures Functions Packages Sanity check Index

ACS3 Data Model

Arguments Source

APM_VERSION_COMPARE

Arguments:

NameData TypeDefault ValueIn/Out
V_VERSION_NAME_AVARCHAR2 IN
V_VERSION_NAME_BVARCHAR2 IN

Returns:

INTEGER(38.0)

Source

Source
     1: function apm_version_compare(v_version_name_a in varchar, v_version_name_b in varchar) return integer is
     2:     a_order_a varchar(1000);
     3:     a_order_b varchar(1000);
     4: begin
     5:     a_order_a := apm_version_order(v_version_name_a);
     6:     a_order_b := apm_version_order(v_version_name_b);
     7:     if a_order_a < a_order_b then
     8:         return -1;
     9:     elsif a_order_a > a_order_b then
    10:         return 1;
    11:     end if;
    12:     return 0;
    13: end;


Generated by OraSchemaDoc, (c) Aram Kananov, 2002