Oracle multiple column single Alias <p>I am trying to select multiple columns and concatenate them in one column with a plus sign and one space on both sides of this plus sign in Oracle 11.2.0.1.0</p> <pre><code>SELECT ename AS Emplyee_name , deptno AS Department_Number , comm+" + " + sal AS This_Month_Comm_and_sal FROM emp WHERE ename = 'AHMAD'; </code></pre> <p>I am getting this error </p> <blockquote> <p>ORA-00904: " + ": invalid identifier</p> </blockquote> <p>same is done in this w3schools tutorial <a href="http://www.w3schools.com/sql/trysql.asp?filename=trysql_select_alias_column2&amp;ss=-1" rel="nofollow">W3schools SQL tutorial</a></p> <p>how can I achieve the same result in ORACLE?</p>