sql - Return everything after specific value -


this question has answer here:

working on 10g.

i tried write regexp removes before first dash(-).

however, did not anticipate complexity of syntax.

i have this:

regexp_substr (myval, '[^"]+') 

this removes values after first double quotation leaving me data like:

10-3/4, 5-1/2, 7-5/8 

i assumed changing double quotes dash , putting carat after dash it, no luck.

if that's need do, don't need use regex, since other simpler functions:

select substring(myval,instr(myval,'-'),length(myval)) yourtable 

Comments

Popular posts from this blog

css - Which browser returns the correct result for getBoundingClientRect of an SVG element? -

gcc - Calling fftR4() in c from assembly -

Function that returns a formatted array in VBA -