Filter Data by strings in Oracle
In a table tab1, there is data like below.
Regular expression to fetch values between pipe sign
I have a string RE|BN|FLEX100|D7|LMB1333| and I am trying to extract the value between 2nd and 3rd ‘|’ i.e. FLEX100.
In a table tab1, there is data like below.
I have a string RE|BN|FLEX100|D7|LMB1333| and I am trying to extract the value between 2nd and 3rd ‘|’ i.e. FLEX100.