By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
SELECT REGEXP_SUBSTR('123.456.578.910.ABC','^(\d+(\.\d+)*)', 1, 1, NULL, 1)
FROM dual;
REGEXP_SUBSTR('123.456.578.910.ABC','^(\D+(.\D+)*)',1,1,NULL,1) |
---|
123.456.578.910 |