const g_radius_earth_miles

g_radius_earth_miles constant number:=3443.917

const g_latitude_direction_north

g_latitude_direction_north constant varchar2(1):='N'

const g_latitude_direction_south

g_latitude_direction_south constant varchar2(1):='S'

const g_longitude_direction_east

g_longitude_direction_east constant varchar2(1):='E'

const g_longitude_direction_west

g_longitude_direction_west constant varchar2(1):='W'

function get_ecliptic_degree

function get_ecliptic_degree(
    p_degree in number,
    p_direction in varchar2
) return number

get ecliptic degree of position

function get_ecliptic_distance

function get_ecliptic_distance(
    p_from_latitude in number,
    p_from_longitude in number,
    p_to_latitude in number,
    p_to_longitude in number,
    p_radius in number:=g_radius_earth_miles
) return number

get distance between to geographic position