CODEWITHSUNDEEP
sqloracle-databaseoracle-apex
VisualNewbie
VisualNewbie

Reputation: 3

Oracle Apex Calendar Display Column

I have to make a calendar, which has events, that show workers reason why they are on a vacation, their name and surname. Under the attributes section I can only chose one column. I have seen a code that should join three columns into one and then display them as one event in the calendar. Is there any way I can put more information into the display column section?

Upvotes: 0

Views: 708

Answers (1)

Littlefoot
Littlefoot

Reputation: 142743

I have seen a code that should join three columns into one

That "code" is called concatenation. As you'd concatenate 3 columns, use the double pipe || concatenation operator, e.g.

select e.first_name||' '|| e.last_name ||' ('|| v.reason ||')' result
from employee e join vacation v on v.empid = e.empid
where ...

Upvotes: 2

Related Questions