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.

M Khalid Junaid · Accepted Answer · 2013-12-22 07:33:06Z

1

For oracle 10g try this one

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

answered Dec 22, 2013 at 7:33

M Khalid Junaid

64.5k10 gold badges93 silver badges120 bronze badges

Sign up to request clarification or add additional context in comments.

1 Answer 1