angel7170
asked on
Parsing in Oracle SQL
Hi,
I need help with parsing a column in Oracle. Please see attached is the example of the current dataset and expected outcome. In the attached spreadsheet,"DIFFCOLS" column stores data separated in a new line and with colons(:). I need them parsed into 3 separate columns(Column name, src and tgt) and rows based on the serial number that is key value. Please see attached is the example of the current dataset and expected outcome.
Thank you
sample.xlsx
I need help with parsing a column in Oracle. Please see attached is the example of the current dataset and expected outcome. In the attached spreadsheet,"DIFFCOLS" column stores data separated in a new line and with colons(:). I need them parsed into 3 separate columns(Column name, src and tgt) and rows based on the serial number that is key value. Please see attached is the example of the current dataset and expected outcome.
Thank you
sample.xlsx
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER