select ‘The Job id for ‘ || upper(FIRST_NAME) || ‘ ‘ || upper(LAST_NAME) || ‘ is ‘ || lower(job_id) as “EMPLOYEE DEFAILS” FROM EMPLOYEES;
oracle的sql例子
发表评论
select ‘The Job id for ‘ || upper(FIRST_NAME) || ‘ ‘ || upper(LAST_NAME) || ‘ is ‘ || lower(job_id) as “EMPLOYEE DEFAILS” FROM EMPLOYEES;