Hello everyone. I'm working on 18c Oracle Database.
From other source, I have to extract a table which have three columns where particular column value are separated in pipe (|) delimiter.The table looks like following :
| ID1 | A | B | C | 10|20|30 |
| ID2 | A | D | A | 50|60|70 |
| ID3 | C | D | A | 100|200|300 |
| ID4 | A | A | D | B | 99|88|77|50 |
My requirement is to find only A value and resultant output will be :
OUTPUT :
| ID1 | A | 10 |
| ID2 | A | A | 50|70 |
| ID3 | A | 300 |
| ID4 | A | A | 99|88 |
Any idea to return this output using sql (regular expression or any analytics fnc) for this data pattern ?
Thanks in advance.