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!

Concat Name

user10441472Jan 20 2010 — edited Jan 20 2010
HI,

I am concatenating First name , middle name and last name I am using following formula

CONCAT(""."FIRST_NAME", CONCAT(', ', "LAST_NAME"))

If I don’t have middle name 2 commas should not display same if we don’t have last name then comma should not display .
I mean if we have more than first name then only comma or space should display. How can I resolve this issue please help me.
I am really appreciated for your help.
This post has been answered by 646090 on Jan 20 2010
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Feb 17 2010
Added on Jan 20 2010
#business-intelligence-applications, #business-intelligence-foundation, #business-intelligence-suite-enterprise-edition-obiee
1 comment
1,770 views