help to split out values SQL
on 11G
not sure which Function to employ, but I need to split 2 values out of a value that exists and assign those 2 extracts to new columns, here is what I mean:
Say the value in the row for a column is: 99_B
I need to remove the number 99 before the underscore and assign that to a new column
I need to remove the B after the underscore and assign that to a new column too
Of course there will be many rows, with NUMBER_singleletter value
I am sure this is something easy, just not sure....
Thank you.