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