Oracle OCP 官方PPT学习日志 使用 SQL SELECT 语句检索数据 01
时间:2022-03-15 12:04
-
连接运算符,||
注:也可以将日期表达式连接到其他表达式或列。
-
文字字符串
SELECT last_name ||‘ is a ‘||job_id AS "Employee Details" FROM employees;
-
其它引号(q)运算符
SELECT department_name || q‘[ Department‘s Manager Id: ]‘ || manager_id AS "Department and Manager" FROM departments;