select ename||',is the'||job from emp

select ename,||'is the||job from emp

select 'ename'||'is the'||'job' from from emp

select ename||concat('is the',job) from emp