sql - Return everything after specific value -
this question has answer here:
- convert fraction decimal [closed] 1 answer
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
Post a Comment