Version and Patches

Example 1

select max(patch_version) as patch_version
  from apex_patches
  where patch_number = (select max(patch_number) from apex_patches)

Example 2

select version_no
,      to_number( regexp_substr(version_no, '[^.]+', 1, 1) ) as v1
,      to_number( regexp_substr(version_no, '[^.]+', 1, 2) ) as v2
,      to_number( regexp_substr(version_no, '[^.]+', 1, 3) ) as v3
,      to_number( regexp_substr(version_no, '[^.]+', 1, 4) ) as v4
,      to_number( regexp_substr(version_no, '[^.]+', 1, 5) ) as v5
from apex_release