Wednesday, 14 August 2013

Sql query to show all column values as a single statement adding some strings related to each other

Sql query to show all column values as a single statement adding some
strings related to each other

I have EMP table its columns as per Scott in Oracle. I want to show all
columns in a single column named 'statement' like below.
ex-FORD IS A ANALYST AND HIS MANAGER IS JONES HAVING SALARY 3000 FROM
DEPARTMENT RESEARCH
KING IS A PRESIDENT AND HIS MANAGER IS NONE HAVING SALARY 5000 FROM
DEPARTMENT ACCOUNTING

No comments:

Post a Comment