PL/SQL SUBSTR and INSTR

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

--result: nurhak.kaya

Comments

Popular posts from this blog

Solution for "Can not obtain Oracle client information from registry"

Solution for the fault: "System.Diagnostics.Process.Start is not working on IIS, but working on ASP.NET Development Server"