I have two columns ID (NUMBER), DESCRIPTION (VARCHAR2(4000)) in Origional Table
DESCRIPTION column has multiline strings. I need to extract dates from each line of the string and also need to find earliest date. so the result would look like in Expected result table..
Expected result, Original Table Using this query to_date((regexp_substr(A.Description , 'd{1,2}/d{1,2}/d{4}')), 'MM-DD-YYYY') I was able to extract date from the first line (Discontinued:09/10/2015:Rappaport Family Institute for Research:;) only, but not from the other two.
