Mar 2, 2010

Concatenation operator in Oracle

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

No comments:

Post a Comment