Problem description & analysis:
There are four strings separated into two parts by vertical bar, namely: ID|DUE_DATE, 80781|2026–12–01, VARCHAR2|DATE, |yyyy-mm-dd.
Task: Now we need to generate a four-field result set, extract the first part of each ...