CODEWITHSUNDEEP
sqloracle-databaseoracle-apex
Jaav
Jaav

Reputation: 37

Adding columns and returning sum to select list in APEX

I'm having trouble adding three columns: first name, second name and surname together for example "Bob Bobby Smith" and returning them to display in select list item in Oracle Apex. Can't find anything on the internet, i'm not even sure if it's possible.

Upvotes: 0

Views: 191

Answers (1)

Gordon Linoff
Gordon Linoff

Reputation: 1269873

Are you looking for ||, the string concatenation operator?

select (firstname || ' ' || secondname || ' ' || surname) as fullname
from t;

Upvotes: 1

Related Questions