concat() will take only 2 arguments, concat(city,', ',state) is not working in Oracle. How did you get solution with it please clarify my doubt.

Answer 1

With oracle is better use || instead of concat, example: SELECT 'Name is ' || last_name
FROM employees;

Answer 2

there is no such keyword as concat in Oracle. But you can use '||' as it provide same output as concat.