Coder Circle

embed a message in SQL

How to embed a message in SQL

SELECT ENAME||’ ‘||’is in the position of ’||’ ‘||JOB||’ ‘||’and his earning is || ‘ ‘||SAL “Employee Details” FROM EMP;

Look at the usage of quodes (’) and the concatination symbols ||

The blank spaces have been mentioned within quodes to display the required additional blanks between words.

Leave a Comment