Oracle 21c

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

ALTER SESSION SET NLS_DATE_FORMAT = 'YYYY-MM-DD HH24:MI:SS';
CREATE TABLE planet (
  location NUMBER(15,10)
); 
INSERT INTO planet (location) VALUES (0.2409219999);
1 rows affected

SELECT * FROM planet WHERE location LIKE '.240921%'

LOCATION

.2409219999

SELECT * FROM planet WHERE TO_CHAR(location, 'fm990.0000000000') LIKE '0.240921%'

LOCATION

.2409219999

SELECT *
FROM   planet
WHERE  location >= 0.240921
AND    location <  0.240922

LOCATION

.2409219999