CONCAT in sql developer

Question

it does not runing,please show me where I have a mistake?

SELECT CONCAT(FIRST_NAME,',',LAST_NAME) as full_name FROM EMPLOYEES;

Did you check the documentation to see how many is a valid number of arguments? — ADyson, Oct 01 '18 at 09:26
For future reference, StackOverflow is a massive repository of previously answered questions. A search on `[oracle] concat ora-00909` would quickly have given you a solution. — APC, Oct 01 '18 at 10:02

jarlh · Accepted Answer · 2018-10-01T09:26:11.533

4

Use ANSI SQL's || instead to concat:

SELECT FIRST_NAME || ',' || LAST_NAME as full_name FROM EMPLOYEES;

(CONCAT() function takes two arguments only.)

edited Oct 01 '18 at 09:26

answered Oct 01 '18 at 09:25

jarlh

I know that but want test with CONCAT functions – Kanbarzadeh Nurlan Oct 01 '18 at 09:26
1

Why? `||` is portable and flexible. – jarlh Oct 01 '18 at 09:27

score 4 · Answer 2 · answered Oct 01 '18 at 09:26

4

Concat only expects two Parameter, so you have to use nested concats:

SELECT CONCAT(CONCAT(FIRST_NAME,','), LAST_NAME) as full_name FROM EMPLOYEES;

For more informations see the Oracle documentation

answered Oct 01 '18 at 09:26

Jens

score 3 · Answer 3 · answered Oct 01 '18 at 09:26

3

concat takes 2 arguments. Try using it twice, like:

SELECT CONCAT(CONCAT(FIRST_NAME,','), LAST_NAME) as full_name FROM EMPLOYEES;

answered Oct 01 '18 at 09:26

apomene

score 2 · Answer 4 · answered Oct 01 '18 at 09:29

2

concat(String, String) is only use 2 parameters. If you want use ','

SELECT FIRST_NAME||','||LAST_NAME as full_name FROM EMPLOYEES

answered Oct 01 '18 at 09:29

develtype

4 Answers4