Organizational Research By

Surprising Reserch Topic

string concatenation operator in oracle postgres and sql server


string concatenation operator in oracle postgres and sql server  using -'sql-server,database,oracle,postgresql'

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

In Oracle we uses '|', postgres uses '||' 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.
    

asked Oct 13, 2015 by amit_cmps
0 votes
8 views



Related Hot Questions

3 Answers

0 votes
NULL
answered Oct 13, 2015 by manju bhargava
0 votes
NULL
answered Oct 13, 2015 by dhananjayksharma
0 votes
NULL
answered Oct 13, 2015 by vijaygupta1980

...