Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> Re: software version number datatype
Best practice for now is to store four separate number values and
compare.
blnCondition := false;
IF majorNum > testMajorNum THEN
blnCondition := true; ELSIF (majorNum = testMajorNum) and (minorNum > testMinorNum) THEN blnCondition := true; ELSIF (majorNum = testMajorNum) and (minorNum = testMinorNum) and
and (revisionNum >= testRevisionNum)THEN
![]() |
![]() |