String concatenation operator in Oracle, Postgres and SQL Server

Viewed 23496

Is there a way to have a common operator for concatenation in Oracle, Postgres and SQL Server.

In Oracle and Postgres we use || and SQL Server uses +.

I've solved the problem in Postgres by adding the custom operator + to support string concatenation.

Is there a way to add the same operator in Oracle to support string concatenation using the + operator.

3 Answers
Related