Skip to Main Content
Forums

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!

How to Concat multiple columns to single column at the report level

1014125Jun 17 2013 — edited Jun 18 2013

Hi All,

I have a requirement in such a way that I have to concat multiple colulmns to single column at the report level.

First of all the column I am using in my report is "X" with datatype as Integer. Now  if the length of this column "X" is <8 then I have add zero's (0) before the number.

And then I have to concat with a column "Y" and then cocnat with a column "Z" and finally the datatype should be casted to CHAR.

Can anyone please let me know the logic how I can add to my column so that it satisfies all the above.

Thanks All
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jul 16 2013
Added on Jun 17 2013
#business-intelligence-applications, #business-intelligence-foundation, #business-intelligence-suite-enterprise-edition-obiee
5 comments
2,076 views