Pre Exam Test Practice (SSC | Banking | IAS | GATE | State Level | CLAT | Railways | Insurance | Teaching Exams | NDA | Defence | IES |State Exam )

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



Government Jobs Opening


...