how to concatenate more than two columns in plsql developer?

Question

when I run the below query

select concat(column1,column2,column3)  as concatcolumn from table

I get an error "ORA-00909:INVALID NUMBER OF ARGUMENTS"

score 3 · Accepted Answer · answered Apr 28 '15 at 11:33

3

Use the concatenation operator:

select column1 || column2 || column3 ...

answered Apr 28 '15 at 11:33

Mark Leiber

score -4 · Answer 2 · edited Apr 28 '15 at 11:50

-4

select ([column1]+','+[column2]+','+[column3]) as concatcolumn from table

Try above the query.it may changes on different type of column data type.

edited Apr 28 '15 at 11:50

Praxis Ashelin

answered Apr 28 '15 at 11:19

muthukumar

Oracle uses `||` as the string concatenation operator, not `+`; and doesn't enclose column names in square brackets. The OP also hasn't asked for commas between the values. – Alex Poole Apr 28 '15 at 11:52

2 Answers2