Skip to Main Content

Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

split one column into two

ABC FunFeb 10 2025

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

Comments
Post Details
Added on Feb 10 2025
0 comments
97 views