oracle - Split string into tokens in pl sql -


how can parse string tokens in pl/sql?

for example, string:

170823-14785 

and parsing want is:

17 08 23 -1 47 85 

as see, want replace consecutive 2 chars, following space symbol

if so, this: (no pl/sql needed this)

select regexp_replace('170823-14785', '(.{2})', '\1 ') dual; 

Comments

Popular posts from this blog

javascript - Clear button on addentry page doesn't work -

python - Error: Unresolved reference 'selenium' What is the reason? -

asp.net ajax - Jquery scroll to element just goes to top of page -