How about
select ename || ename from emp;

you can filter the result by using where clause