select phone_number, substr(phone_number, instr(phone_number, '.', 1,1)+1, instr(phone_number, '.', 1,2)-instr(phone_number, '.', 1,1)) melumat from hr.employees ...
The original instr content comes from 61ae6ff (First three lessons on SQL for beginners, 2013-11-09). The commit message there doesn't motivate this particular example (it's adding a lot of other ...