Skip to Main Content

Analytics 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!

OBIEE Columns concatenation in answers

AdiseshuSep 5 2013 — edited Sep 6 2013

Hi,

I have a requirement where I need to concatenate 2 numerical columns in between '-'.

for ex: column1 value -  12345

column2 value - 67

then the result should be '12345-67'

I have used this statement in column formula

cast((column1) || '-' || ( column2) as varchar).

I am getting syntax error. Can somebody please help.

Thanks,

Seshu.

This post has been answered by SriniVEERAVALLI on Sep 5 2013
Jump to Answer

Comments

Solomon Yakobson
Answer
select  to_char(trunc(entry_date,'MM'),'MM YYYY),
        sum(qty) qty
  from  your_table_name
  group by trunc(entry_date,'MM')
  order by trunc(entry_date,'MM')
/

SY.

Marked as Answer by SANPAT · Aug 9 2022
1 - 1
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Oct 4 2013
Added on Sep 5 2013
2 comments
13,332 views