I've received a new file to import in our database and the *censored* DBA are the other end got creative with the format. he decided to use 0x01 as field delimiters and 0x02,0x0a,0x10 as record ...
So I've a delimited string in a database, and I'd like to turn the string into rows. Pretty simple so far. The complication is a 2-level hierarchy of data within the string. In Oracle 12. The context ...