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!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

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

Added on Feb 10 2025

#help

0 comments

35 views