what this mean ||

hi there,

I am just trying to learn SQL, if u can help.

I have Emp Table with the following 3 colomns ename, Salary, Dept No.

Question:
the statement:
SQL> Select 'Name: ' || ename "Employee", Salary "Salary" From emp
where deptno = 30
order by deptno Desc, "Employee"

Why || is used here ???
why 'Name: ' is used here, it is not a column Name.???

thanks

Imen Received on Sun Jun 24 2001 - 16:39:55 CDT