Concatenation Operator in Oracle

Bubbly
Posted by Bubbly under Others category on | Views : 2561
The concatenation operator will concatenate columns or character strings to other columns. Represented by two vertical bars (||).

For example,
SELECT lastname||jobcode  as "Employees" FROM tblEmployee;

It will result as
Employees 
xyz_VP
abc_PRES
pqr_VP

Comments or Responses

Login to post response