How to list a group of coordinates(latitude, longitude) in an Oracle 11g SQL table in a radius

Question

I need to list a group of coordinates in a radius of 500m.

I have a name table TB_COORDENADAS, with the columns LATITUDE and LONGITUDE.

I wish to point out a coordinate (lat, lng) and list all coordinates in the table that are in a radius of 500m.

What would be the best solution to my problem?

I have found solutions that would work in Mysql, but in Oracle 11g do not run. I need the result to be a list of latitude and longitude and not the distance between one point and another.