CONCAT in MySQL takes any number of values.
CONCAT in Oracle takes only TWO values.
Nested CONCAT statements can mimic the MySQL behavior, but that’s tremendously ugly.
Instead use the concatenation operator, ‘||’, like so:
SELECT ‘Hello’ || ’ ’ || ‘World’ FROM DUAL;