[Solved] CONCAT in sql developer [duplicate]

Question

Use ANSI SQL’s || instead to concat:

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

(CONCAT() function takes two arguments only.)

Accepted Answer

Use ANSI SQL’s || instead to concat:

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

(CONCAT() function takes two arguments only.)