Skip to Main Content

SQL & PL/SQL

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!

concat 2 columns

TKQ5QFeb 9 2022 — edited Feb 9 2022

Hi all
I am using using Enterprise Edition 11.1.1.7 to concat 2 column as follow but encounter error.
concat (YEAR("Shopname"."Sale Date (Calendar)") ,MONTH("Shopname"."Sale Date (Calendar)"))
Capture (1).PNG
can anyone advice? Thank you in advance.

This post has been answered by BEDE on Feb 9 2022
Jump to Answer
Comments
Post Details
Added on Feb 9 2022
4 comments
173 views