CONCATENATION OPERATOR (||) IN ORACLE

In oracle if you want to display column data along with literal strings then we must use concatenation operator.

Example -

select 'my employee name is '||ename from emp;