Concat multiple columns with string in oracle

Question

I have problem with following sql code:error says

apex -ORA-00907: missing right parenthesis

SELECT (ime,', ',prez,', ',br_tel) AS POŠTARI
FROM postari

It keeps telling me I miss right parenthesis.

I want multiple columns to be selected as ALIAS, because it works on mySql but I do not really know how to do it here.

Answer 1

For oracle 10g try this one

SELECT (ime||  ',' || prez|| ',' || br_tel) "POŠTARI"
FROM postari

Concatenation Operator