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.
How to use an aliase name in the SELECT clause in Oracle
However, instead of ename and job the column headings should be empname and jobrole. The query that will solve our purpose will be:
SELECT ENAME EMPNAME, JOB JOBROLE FROM EMP;
The fun comes, if you want a space in between. Like if you want JOBROLE should [...]
NULL in Oracle means empty. You need really a special mechanism to handle NULL values in Oracle
Oracle supoorts the NVL function to handle NULL values.
NULL means empty, so it is neither zero nor spaces. NULL value takes place, when the user does not enter any data in the respective columns.
So, if you encounter a null [...]