How to display the letiral as a separte column.

How to display the letiral as a separte column

For example suppose that you want to create a result that detailes employee names and thire job .titels linked by the litieral string ‘is a ‘ .when you place the literal ‘is a ’ between the cloumn names in the select list , the ruselt produced a separate cloumn contining the literal string.

BLEASE CHECK THE BELOW EXAMPLE.

SELECT ENAME ,’IS A’,JOB

FROM EMP;

------------------------------------

ENAME      'ISA JOB

---------- ---- ---------

SMITH      IS A CLERK

ALLEN      IS A SALESMAN

WARD       IS A SALESMAN

JONES      IS A MANAGER

MARTIN     IS A SALESMAN

BLAKE      IS A MANAGER

CLARK      IS A MANAGER

SCOTT      IS A ANALYST

KING       IS A PRESIDENT

TURNER     IS A SALESMAN

ADAMS      IS A CLERK

ENAME      'ISA JOB

---------- ---- ---------

JAMES      IS A CLERK

FORD       IS A ANALYST

MILLER     IS A CLERK