Hi everyone! I am new to Oracle, and usually write queries for t-SQL. I have a query that produces around 11 fields, and one of which is a multi-delimited field and the other 10 are dimension fields. I would like to split that field into several rows, and have the other 10 fields just repeated for each one. Here is an example of the data in the 11th field: Column 11 34^56^78,59 There are two delimiters in the field, a carat and a comma. This field is used to reference document numbers that are needed to be sent in. The carat represents the word "Or" and the comma represents the word "And". I would like to have the output of each field to be a repeat of the 10 dimension fields, plus 3 new fields. The first new field would be the document number, the second new field would be the position within the original delimited field(1, 2, 3, etc.) , and the last field would be one of three logic words :First (if it is the first value), Or (if the value followed a carat), And (If the value followed a comma). Example of the output from the above value would be (please ignore the underlines, i just did that to maintain spacing): Column 11 Column 12 Column 13 34_______ 1_______ First 56_______ 2_______ Or 78_______ 3_______ Or 59_______ 4_______ And Any thoughts on this? I have found a few solutions online on how to break up the delimited field into rows, but never with multiple delimiters or with extra logic for the added fields. Any help would be SUPER appreciated! ^_^ Thanks in advance!