Use ANSI SQL’s ||
instead to concat:
SELECT FIRST_NAME || ',' || LAST_NAME as full_name FROM EMPLOYEES;
(CONCAT()
function takes two arguments only.)
2
solved CONCAT in sql developer [duplicate]
Use ANSI SQL’s ||
instead to concat:
SELECT FIRST_NAME || ',' || LAST_NAME as full_name FROM EMPLOYEES;
(CONCAT()
function takes two arguments only.)
2
solved CONCAT in sql developer [duplicate]