How to get the first two octets in an IP address Oracle SQL E.g., IP = '10.11.12.13'
I want to extract '10.11.' or everything except what comes after the 2nd '.'
I know you have an accepted answer but just for completeness here's an option without REGEX;

SELECT SUBSTR(your_field,1,INSTR(your_field,'.',1,2)-1)
FROM dual