【文件属性】:
文件名称:使用串接操作符-SQL语言基础
文件大小:5.26MB
文件格式:PPT
更新时间:2021-04-25 19:38:07
SQL 基础
使用串接操作符
*
SQL> SELECT ename||job AS "Employees"
2 FROM emp;
Employees
-------------------
KINGPRESIDENT
BLAKEMANAGER
CLARKMANAGER
JONESMANAGER
MARTINSALESMAN
ALLENSALESMAN
...
14 rows selected.
*
SELECT ename||job AS "Employees"
FROM emp;
Concatenation Operator (continued)
In the example, ENAME and JOB are concatenated, and they are given the alias Employees. Notice that the employee number and job are combined to make a single output column.
The AS keyword before the alias name makes the SELECT clause easier to read.