Posts

Showing posts from May, 2014

PL/SQL SUBSTR and INSTR

select substr('nurhak.kaya_1234', 1, instr('nurhak.kaya_1234', '_') -1)
from dual;

--result: nurhak.kaya