Hello,
I would like to have split vendmemo column into two column
In sample data file Column A is original column. My desire output in Column G and H in green highlighted
SELECT LEMNUM, VENDMEMO,WORKDATE
FROM LF
WHERE LF.WORKDATE > CURRENT_DATE - 50
sample data-Oracle.xlsx
Thanks lots