Hi ,
I have a column having data type as varchar2. Data in that column will be like below in one row in below format.
[Errors [code=ERR0066, description=ABC must be greater than 500],Errors [code=ERR0067, description=DEF must be greater than 454],Errors [code=ERR0066, description=ABC must be greater than 500],Errors [code=ERR0067, description=DEF must be greater than 454]]
Now I need to convert above string data into rows and distinct errors records has to show. like following
Columnname
Errors [code=ERR0066, description=ABC must be greater than 500]
Errors [code=ERR0067, description=DEF must be greater than 454]
Can you help by providing the SQL query to get above result