Oracle中字段拼接符”||“
如果想将first_name和last_name合并成一个字段显示,且字段标题设置为Name,其SQL语句如下:
SELECT first_name || last_name AS "Name",salary*12+500 AS "Yearly Salary" FROM employees
Oracle中字段拼接符”||“
如果想将first_name和last_name合并成一个字段显示,且字段标题设置为Name,其SQL语句如下:
SELECT first_name || last_name AS "Name",salary*12+500 AS "Yearly Salary" FROM employees